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.
Help Article Resources
Check out the Formula Handbook template!