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

A O
A O
edited 12/09/19 in Archived 2016 Posts

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 discussion has been closed.