Inconsistent incorrect %


Hello -

You will see below, I have a formula that, when copied into all of the column cells, the % calculation is incorrect inconsistently. Some are correct, eg, 33%, and others are not, eg, anything over 100%. The formula and cell formatting is the same for each cell in column "% Complete.

I do know I can separate two of the columns for the formula (remove one of the countifs, but another column will soon be added that will not be part of the formula :-)

Any help in correcting the percentages would be appreciated!


Best Answer


  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Ellyn S

    Add parenthesis around all your COUNTIFS.

    Your current formula is calculating the the last COUNTIF result / 9 then adding the result of the first 2 COUNTIF functions

  • Ellyn S

    Thank you, Leibel. That did it!

    It's so weird, though, that it it is the same formula for each cell in the column (I slowly triple checked the cells paying close attention the parentheses) and some are calculating correctly and some are not.

    I'll take the win that it worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!