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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!