Setting Dates Based on Other Dates

I’ve got a board with 4 dates columns in it. When I set the first date, I want the other three dates (which are due date columns) to be automatically set at varied intervals (for Due Date 1, 11 days before Post Date, for Due Date 2, 9 days before Post Date, etc). Is this possible? Using automations, figured out how to adjust the dates if they’re already set, but I can’t figure out how to set the dates. Thanks for any input!

Some background if helpful: This board is essentially a social media calendar. Post Date is the date the post will go live. Due Date 1 is when the “Creation” stage should be completed, Due Date 2 is when the Approval stage should be done, and Due Date 3 represents the due date for the post being “Scheduled”

1 Like

Hey @radicalmentoring, interesting case here. One thought, you could set all 4 dates via automation when the item is initially created and then use your current automations to push the dates when the post date is changed?

image

Thanks,
Mark

Hey Mark! Thanks for taking a minute to provide feedback. I think your idea would definitely
work, although it’s still an extra from what I’d love to happen. Gotta take what we can get though, right? I will pitch it to the guy who will be working off this board and see if he finds this solution helpful!

I’ve run into this a couple of other times as well. I think Mark’s solution is pretty good if you need each date to trigger another automation. The problem is that the dates are set at item creation are a little misleading until Date gets set.

Another option which I recently discovered is to set formula columns to equal the other dates.
FORMAT_DATE(ADD_DAYS({Date},11),“YYYY-MM-DD”). Problem with this is you can’t trigger automation on formula/date column
BUT if you need to trigger an automation based on ‘Date1’ or ‘Date2’ then you can set an automation to run “N” number of days AFTER the date arrives. see a sample. I’ve just set this up a couple of days ago, but logically it all works out, and I think is the best solution for this type of use-case.


Let me know if you use it and if it works out!

Hey Tim, thanks for sending your thoughts on this. I got the formula to work (first time I messed with formulas on Monday.com, pretty cool!) in that it will populate the column with the date I want. Only problem now is that because it’s a formula column, it can’t be connected up my a status column as a “deadline.” It would still take an extra step to go and set the due date columns to match the formula columns so I’m thinking it’s probably just easier to set them all manually, unless I’m missing something obvious that you see!

Gotcha, yes I think that may be a limitation. I have successfully used integromat for doing a real automation to set Date1 N number of Days after Date2. And its a pretty straightforward scenario. But if that’s the only thing you are looking to do in integromat then setting the column manually may very well be the best way forward. (especially since you need the deadline feature.)

FYI The integromat scenario does successfully work with deadlines in case you are interested.

Best!