Cell in a report that has no data is displaying a "0" - how to remove this?


We're pulling a report where many of the cells are empty. However on the report there is a 0 showing in all the cells. I've attached a screenshot to show some of the cells in question. It's an issue throughout the entire report/sheet, not just the one column shown.

How do we remove the 0 so the cells are actually empty/blank without changing or deleting any forumulas in other cells?

To be honest, I'm not sure if this is a formula issue or formatting, so my apologies if I've put this question in the wrong area.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!