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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!