Recurring tasks that need their due date to update regularly


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
    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))

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • EmilyE
    EmilyE ✭✭✭

    Thank you, Amber! I will try that!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!