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

Options

I would like to make certain columns on a sheet that has empty or blank cells to show $0.00, rather than being blank. Can I create a formula that says "if a cell is blank, make it show $0.00"?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!