How do i make an empty or blank cell equal "$0.00" in Smartsheet?

Hi @Andrew Hales

Yes, you can, but if it will work depends on your specific structure.

Would that column only need to show the values, or would you need to add values as well?

I hope that helps!

Be safe and have a fantastic day!

Best,

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

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

@Andrew Hales

I'd recommend adding a so-called helper column (Excel) to paste the column's data and then add something like below (format it to USD Currency Format).

=IF(Excel@row = "", 0; Excel@row)

Make sense?

Would that work?

@Andrew Hales

Ok.

You'd only need to add one helper column, or are there multiple columns that you'd need to work the same way.

@Andrew Hales

It might be possible to structure something with either the Smartsheet API or a 3rd party service like Zapier.

Are any of those an option?

@Andrew Hales

Not sure I follow!

Can you elaborate?