Count rows by % Completed?

edited 12/09/19 in Formulas and Functions

Is there a way to count rows by % completed.  For example, how many items are greater than 50% completed?  I'm getting UNPARSEALBE

I tried a formula like this (but also tried converting % into decimals.... =COUNTIF([% Completel]:[% Complete], >50%)

Note:  also see that the % completed column is part of the Project Properties. 





  • Brian W
    Brian W ✭✭

    It should work if you use this formula:

    =COUNTIF([% Complete]:[% Complete], >0.5)

    (I noticed you have a typo in your original formula, which could possibly be contributing to the unparseable error.)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!