Clear Cells if Time Is

A O

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.

JohnHinkle

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.