Automate Daily Clearing of certain column in a sheet
I was wondering if it is possible to automatically clear certain columns in a sheet based on a date or change trigger. We are using Smartsheet as a parts database and after filling out the Quantity, Job# ect. and checking a box the row is added to another sheet to be approved and ordered. I would like to clear these columns daily so parts can be ordered again without having to clear these columns manually.
Help Article Resources
Check out the Formula Handbook template!