How to show a blank instead of 0 using countsif?

Mar_star

I've tried a couple different formulas and can't get it to work, probably something small I am missing. Can anyone help?

=IF({MY25 CTM Detail Report Range 1} = 0, " ", COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review"))

Kerry St. Thomas

I'm guessing your goal here is to shut down the visual noise created in a sheet if there's zeroes everywhere. So you have two options:

=IF(COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review")=0,"",COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review"))

Basically, create the formula so COUNTIF is mentioned twice: once to evaluate if it's 0, and a second time to tell Smartsheet what to do if it's NOT 0. Your formula is looking at the entire range of what appears to include text, so it's not going to be 0.

Option 2 would keep the value in the cell - possibly helpful if you need to create dashboard visualizations, or if you ever want to do math on this column. (The "" is basically saying "THIS CELL IS TEXT" so you could be forcing an #UNPARSEABLE error.) Don't make it blank, but rather use conditional formatting - if the countif column = 0, color the font in that cell white on white (or to match whatever your default background is).

Whichever direction you decide to go, good luck!