COUNTIF Formula Providing Incorrect Result

kelceyg
kelceyg ✭✭✭✭✭

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.

2023-05-04_16-54-37.jpg 2023-05-04_16-54-52.jpg


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

2023-05-04_16-55-15.jpg


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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!