Convert SOME of the blanks to zeros

Sherry Fox

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.

Andrée Starå

Hi @Sherry Fox

I hope you're well and safe!

You could have a Workflow combined with the Change Cell Action.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sherry Fox

@Andrée Starå

I am not exactly sure how to do that. Could you provide more details please?

Andrée Starå

@Sherry Fox

Try something like this.

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sherry Fox

Andrée Starå,

OMG! I did not even know about Cell Value Change, it was like it was hidden. I never would have solved that without your assistance! That is amazing!!!! That solved my problem. And thanks for the extra assistance of showing me where to find it, greatly appreciated.

Andrée Starå

@Sherry Fox

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!