Automation - Dates!

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!