Convert SOME of the blanks to zeros

I am creating a new sheet, and so far, about 30 columns. Of these columns, 12 are metrics which require a numeric value. I would like to create a Workflow to convert the blanks in ONLY these 12 columns to 0. It is likely that some of my other columns will be blanks, but I do not want them to be converted to zeros. If possible I would like to set my trigger in the row, and then list each column. Then if the user has not made an entry (via the form), it would be blank, but then converted to 0 by the Workflow.

Sherry Fox

Project Analyst | Core Quality Services (QMS Transformation)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!