How to autoREMOVE a checkbox

I have a box in my spreadsheet that people are manually checking to mark the fact that their update is complete/final/approved. They have to do this by the end of the week so I can push a report every Monday. On Tuesday, I would like to remove all the checkmarks automatically so they can re-check the box again. Anyone think of a solution to automatically remove the checkmark?

The things I have considered are:

  1. using a formula - but every time someone checks the box, the formula will be overridden
  2. considering a helper column... but not sure how that would work
  3. manually removing the box every week (but eventually I'll have to be away from the office and this process should live without someone having to manually remove it for me)

Look forward to any creative thought to accomplish this ask. THANK YOU!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!