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

Henry Eyer

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.

Andrée Starå

Hi @Henry Eyer

It’s possible.

There are two way I can think of right now.

• 3rd party integration/service, Zapier
• Move row to other sheet, move from another sheet the default one

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Henry Eyer

It’s possible.

There are two way I can think of right now.

• 3rd party integration/service, Zapier
• Move row to other sheet, move from another sheet the default one

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Henry Eyer

Hi Andr'ee,

Your answer does make sense. Moving the row and then replacing sounds like the way to go.

Thanks,

Henry

Andrée Starå

@Henry Eyer

Excellent!

You're more than welcome!