Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)

edited 12/09/19 in Formulas and Functions

How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the row level, not the sheet level. Is there a formula I can use to do this?  Please help, and thank you for your assistance in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!