I'm trying to set up an automation that generates dates for each step of our approval process, based on the inputted "Go live" date. For example, if the project needs to go live on 7/29, manager approval should be 3 weeks prior and leadership approval should be 2 weeks prior. Does anyone know how to populate this timeline automatically so we don't have to do the math ourselves and it saves us some time?
One way you can set this up is to create a column that calculates how many days from the go-live date column you are. Create a calculated column called "Countdown to go-live":
Then from there you can base your automation on a # value criteria (e.g. email manager for approval when countdown field is <21 days, <14 days etc.)