+1Hi there!
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?
Thank you!
+7Hi Carly,
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.)
+1Thank you! Do you know of a way to make it into a date field as opposed to an automation? We want to have listed dates for each step of approval.
+7If you want a column for each specific date, you can use a formula like this:
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.