Is it possible in automation to have a cell cleared of information each evening?

I have a smartsheet set up where we ask users to update two questions with Yes or No during the day. If we don't delete the info in the cells each night the answers from the previous day show up on their update the following morning. So if they answered Yes to question 1 and No to question 2, they will still see this in their daily request. I've been deleting the answers in the cells each evening but would like to figure out how to do this automatically. It would be great if I could run an automation at midnight that would clear the cells if that is possible.

Best Answer

Answers