Recurring tasks that need their due date to update regularly

EmilyE

Hello!

I am creating a sheet to manage our facility life safety inspections.

Some of them occur monthly, some occur weekly, others semi annually and others annually or more.

What I am hoping to do is create a formula that will update the due date to the next date, after the current inspection has been completed.

I plan to have the completed date entered via an update request.

Is this possible? Or am I dreaming?

Thank you for any wisdom or grounding if I am hoping for too much!

Amber Eakin

Hi @EmilyE - Is the due date so they'll know to complete the item? If that's all, you could set up a recurring Update Request based on the necessary schedule instead of changing the due date several times.

Alternatively, you could make the Due Date based on a "Last Modified" date column. You would add the "Modified date" column, which is an automated column. It can capture when cells OR comments are added/changed in the row. Then, you would make the Due Date column a formula like the one below (which would be for monthly tasks). You would change the "+1" to whatever interval is necessary for the project.

=DATE(YEAR(Modified@row), MONTH(Modified@row) + 1, DAY(Modified@row))

https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

EmilyE

Thank you, Amber! I will try that!