# 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.

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!