COUNTIF Formula Providing Incorrect Result


Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect.

The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct)

I tried this formula on a second sheet and still received an incorrect result.

The correct result for this sheet should be: Complete - 5

Any thoughts on why this might be? The Status column is a single select drop down with conditional formatting.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!