Recurring Cleaning Schedule Setup

I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months).

I had it in my head that I could use Gannt functions to setup the varying Durations of each piece (i.e. 2w, 30d, etc.).

My thought was then to have the team members check a box when cleaning was completed and then use the automation Record a Date to replace the Last Performed date (thus setting the Next Cleaning Date automatically). After that I figured I could do another automation to Reset the Checkbox after a day or so.

The problem comes with the Record a Date Automation not allowing me change my Last Performed date because I have dependencies enabled. I have no need of the predecessors but the Duration column is very useful in this case.

I'm sure there is a simpler way and I'm just missing it.

Tags:

Best Answer

  • marc4
    marc4 ✭✭✭✭
    Answer ✓

    Seems simple enough. Just set up a sheet like this. Next Check is just Last Checked + Interval in Days

    Two automations. One sets the last check date to today when the Task Completed is checked.

    One unchecks Task completed when Last Checked date changes.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!