Need to default a column to a specific value after row is copied to another Sheet
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
Help Article Resources
Check out the Formula Handbook template!