How to count children cells from % complete column - countif not working

This is for my % complete column. I'm trying to count the children tasks if the % Complete is less than 100%.

I'm using this formula: =COUNTIF(CHILDREN([% Complete]):([% Complete]), <100%) but it is not returning a count, just displays the formula as it isn't correct syntax but can't figure it out.

Thanks in advance!

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I would suggest a helper column with this column formula:

    =COUNT(CHILDREN(PercentComplete@row))


    Then your COUNTIF would change to a COUNTIFS and look something like this:

    =COUNTIFS(PercentComplete:PercentComplete, <1, [Helper Column]:[Helper Column], @cell = 0)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!