Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
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
Check out the Formula Handbook template!