Find blank cell and put in "0"

Hi there,

I’m creating daily sales flow but sometimes when we don’t get any sales, we have some blank cells.
I would like to know how to put in 0 (zero) to those blank cells.

Thanks, Akiko

Hey @Akiko! If the cells are blank, you could use the Find and replace step. The step would look like this (leave the value blank and choose whichever column(s) you’d like to apply this to):
Screen Shot 2020-09-22 at 10.56.29


Hi Andrew, Thank you so much for your help. I could fix it!


Adding on to Andrew’s answer, if the above does not work, you can also use a Regex step set up like this: