Automation - Dates!

Elise Rotatori

I have a spreadsheet that I want to update the following cells:

Order Date (this is the date an order is placed)

Start Date (this is the start date of a range for purposes of requesting documents)

End Date (this is the end date of a range)

How can I set up an automation so these dates will automatically update every quarter but not populate before the order date? This seems like an easy set up but I'm stumped! TY

Amber Eakin

Hello, @Elise Rotatori ! Are you using Predecessors? You could set up the Start and End Dates based on the predecessor of the Order Date.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors