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

edited 12/09/19 in Archived 2016 Posts



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.


This discussion has been closed.