Need to default a column to a specific value after row is copied to another Sheet

Good day,

I have a sheet that is used for tracking visitors, at the end of each day all rows in the sheet get copied to another sheet that is used for metrics. Once all the rows are copied I want to set a column to zero so that it can be changed to a value for the next days work.

I have created an automated workflow to do the copy rows to a metrics sheet but cannot figure out how to set the column values for all rows to zero and still allow the cells to be updated.

I have tried using a column formula however that does not allow you to change the cell value

Here is a view of my main sheet the red arrow is the column I am trying to default to zero

Here is my workflow

appreciate the help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!