Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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.

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!

Trending in Formulas and Functions