Help

Re: How to set dates for different checkpoints based on live date

717 0
cancel
Showing results for 
Search instead for 
Did you mean: 
carly515
4 - Data Explorer
4 - Data Explorer

Hi 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!

3 Replies 3
Adrienne_Medina
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi 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":

 

DATETIME_DIFF({date}, TODAY(), 'days')

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.)

 

carly515
4 - Data Explorer
4 - Data Explorer

Thank 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.

Adrienne_Medina
5 - Automation Enthusiast
5 - Automation Enthusiast

If you want a column for each specific date, you can use a formula like this:

DATEADD({go live date},-14,'days')
The example above tells you the date that is 14 days prior to the date in your go live field.