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:
- using a formula - but every time someone checks the box, the formula will be overridden
- considering a helper column... but not sure how that would work
- 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
-
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
-
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!
-
@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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!