How to autoREMOVE a checkbox

Bria Berger

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

John_Foster

Hi @Bria Berger,

To do this I would use an automation process. This can be set so that every Tuesday at a time which you can specify all rows where field X is checked has the row value changed to unchecked.

Hope this helps!

John

Bria Berger

I can't believe it was that simple! I explored the automation for far too long and still missed it! setting it up now! Thank you!

John_Foster

@Bria Berger You are very welcome. I asked a question last week and it was the same. Something so simple that I missed. That's what ewe are here for.