Is there a way to trigger a workflow if an end date changes by 5 or more days?

Denise Heffron

I'm looking to create an automated workflow to copy any row from a project plan that has the end date changed by 5 or more days. Is there a formula I can include in the automated workflow to accomplish this?

Andrée Starå

@Denise Heffron

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You would need to insert two additional columns. One to record the new date and another to check if the new date is more than 5 days difference from the original date. You would then set your automation up based on the check column.

Andrée Starå

Hi @Denise Heffron

Please have a look at my post below with a method I developed that could help.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Denise Heffron

Possibly, yes! I am working with leveraging the copy to a new sheet workflow, but have added columns to compare the dates and determine the variance. Thank you! Denise

Andrée Starå

@Denise Heffron

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!