I’m working on a board that stores three deadlines based on Date1, which is the date we receive permission to start a project.
Date2, which is 2 weeks later, absolutely has to be a Date column because there’s an automation that triggers if it isn’t met.
Date3 occurs 6 weeks after Date2 and is our completion deadline.
Date4 occurs 2 weeks after Date3 and is our delivery deadline.
Date3 and Date4 can be formula columns, but I’d love to be able to trigger them via an automation. “When Date1 changes, change Date2 to Date1 + X days”
The closest prebuilt option is the one with the Numbers column in it, but I reeeeally don’t want to have multiple numbers columns, especially since it’s the same for every. single. job. and we have several hundred lines on this board alone, more added every day.
I’ve applied for inclusion in the custom automations beta, but haven’t heard back from support yet.
Thanks for your time.