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