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

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

Comments