Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Clear Cells if Time Is
Hi,
I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time).
To give you an idea of what it is being used for;
My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be attending the meeting at 2:00pm today". I would like the responses (check boxes) to be cleared every day for a new answer the next day.
Please let me know if more details are needed.
Thank you!
A. O.
Comments
-
This might be possible by building a custom solution with the API but its not with the core features of the app.
You will need to open the sheet and clear the responses. The quickest way to do this is to click on the column header and press Backspace on your keyboard.
-
It looks like that is my best option, thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives