Why isn't my % Complete count if working
I can't get my CountIf formula to work completely on the % Complete Column of my project sheet: =COUNTIF([% Complete]:[% Complete], =100)
It does return return 3 when I have the criterion set to =0. It returns 0 when the criterion is set to =3 or =100. I have tried "3%" and "100%" as well but it still comes back 0. I don't get it.
Best Answer

Happy to help. 👍️
Answers

Try this...
=COUNTIF([% Complete]:[% Complete], =1)

Thank you for your comment. None of the = value work. Its weird and the ultimate problem for me.

Exactly how is your % Complete entered? Do you manually type the "%"?

I've tried the numerical value alone.. 100 lets say. I've tried =100. I've tried "100%"

If you are manually entering the "%" then you are actually generating a text string. If you are entering a plain old number into a text/number column that is formatted as percentages then you have yourself a number.
If the second, when evaluating percentages in a formula, Smartsheet reads a percentage as a piece of 1 whole. So 100% = 1, 50% = .5, 25% = .25, so on and so forth.
If this doesn't work:
=COUNTIF([% Complete]:[% Complete], =1)
Then try this...
=COUNTIF([% Complete]:[% Complete], = "100%")

That was it! Its the decimals for the percentages. Thank you!!! I should have thought of that but I didn't and you helped me out tremendously Paul.

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!