Need help with a function

Ravi Gorthi

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(<Required for:Required for>,"Sprint 2",<Build % Complete:Build % Complete>,"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

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

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(<Required for:Required for>,"Sprint 2",<Build % Complete:Build % Complete>,0)

If that doesn't work, try modifying it to the @cell = 0 as @Mark C. has shown.

Mark Cronk

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

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(<Required for:Required for>,"Sprint 2",<Build % Complete:Build % Complete>,0)

If that doesn't work, try modifying it to the @cell = 0 as @Mark C. has shown.

Ravi Gorthi

Thanks a lot Mark & Mike! Tried both options and works like a charm!

Mike Wilday

Awesome. I'm glad we could help you out!