Setting Dates Based on Other Dates

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!