Question

I have a sheet that has 2 columns Required for (Sprint 1, Sprint 2,.....) Build % Complete (values - 0%, 50%, 100%) I need to know how many Sprint 2 items have 0% Build % Complete. My function is COUNTIFS(,"Sprint 2",,"0%") This function is always returning 0 even when I have rows with 0% in Sprint 2. Can you tell me what I am doing wrong? Appreciate your help

Mark Cronk · Accepted Answer

Hi @Ravi Gorthi ,

Try:

My function is COUNTIFS([Required for]:[Required for], @cell="Sprint 2", [Build % Complete]:[Build % Complete], @cell=0%)

Work?

Mark

Mike Wilday · Accepted Answer

One thing to consider is that Smartsheet displays percentages to the viewer as percentages but is actually storing the formatted percentage as a decimal. Instead of using "0%" try just using 0 with no quotation marks. That small change should do it. COUNTIFS(,"Sprint 2",,0) If that doesn't work, try modifying it to the @cell = 0 as @Mark C. has shown.