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

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

  • It looks like that is my best option, thanks.

This discussion has been closed.