I’m using an automation that says “when button is clicked, create subitems” to create 18 subitems. I am also using two date columns for my subitems - “creation date” and “due date”.
I have two questions with this:
In the automation, I selected “today” on the top as the date to fill in for the “creation date” (see below). Is that a dynamic today? Or will it continue to input today, March 30th, as the creation date every time the automation runs?
I need to push the due dates of some of the subitems +7 days from the creation date, but I need to push other due dates by only +4 days. What is the best way to accomplish this?
I believe the creation date in unfortunately a “hard” one that does not change dynamically. It is unfortunate that currently monday does not support subitems for “when item is created” automations , which would resolve your problems.
Similarly, because these are subitems, we cannot use "when item is created and condition is x this push date by y ".
So it seems to me that currently the only way to do this would be via a platform like Make.com.
If anyone can suggest something else I would also be very interested to know!
Had the exact same issue with this that destroyed the workflow we wanted to create. I believe there’s no solution to this at the moment.
Would be great if the developing team could change the ‘today’ into a dynamic date instead of fixing it on the date. We can select the exact date in the calendar view if we want to hard set it.
The ability to create a dynamic “Today” can be very usefull. I myself needed that ability.
I suggest to put this in the feature request section where the community can vote for it.
The more votes this feature request will get, the better the chance Monday.com will develope it.
I REALLY need the dynamic “Today” to also work for subitems. We have automations that trigger subitems but then the subitems dates are all overdue because we chose “today” when creating them. We tried leaving the date blank, but then nothing shows up in my work. I also tried to run automations that when subitem is created set date to today automation but that doesn’t exist. That would be an easy fix too if we could have an automation that set the subitem date to the day it was created.
After reading this thread, I ended up stumbling upon a work around for this (which is why perhaps the “today” date isn’t dynamic). From what I understand, you can’t push dates from an individual automation, but, you can do that on a “global” automation for your subitems. So, you have to create an automation like this:
This will automate all the subitem dates. It will set it to today’s date and then push it out by how many dates you want.
It wasn’t a logical way to set up the automation (pushing subitem dates for every subitem seemed more logical to me). Although, the more that I think about it, it’s nice not to have to update every single subitem automation and just create a global one.
We developed an app called subitem automations that provides robust automation capabilities to subitems. Here’s an example of how it can be applied in this case →
Automatically setting date to match parent + some offset (based on numbers column) →
There are other more advanced options but tried to keep it simple to give you the gist of it. If you need further help you can reach out to me daniel@fantasymedia.io