Need help with a function

Ravi Gorthi
Ravi Gorthi ✭✭
edited 12/03/20 in Formulas and Functions

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

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!