COUNTIF FORMULA FOR CHILDREN ROW WITH CRITERIA

Shadany

Hello,

I'm trying to set up a formula that counts the children rows in the "Percent completed" column, per parent row. This formula will be put into Column13. But I only want to count the ones that are less than 100% completed. I'm having issues with adding in that criteria. Any suggestions?

Thanks,

Shadany

Paul Newcome

So you want a formula there only on the top row that counts all parents that have at least one child less than 100%?

Shadany

@Paul Newcome it will be a formula that counts the percent completed less than 100% for each item number.

Paul Newcome

Ok. In that case you will need this

=COUNTIFS(DESCENDANTS([Percent completed]@row), @cell<1)

or

=COUNTIFS(CHILDREN([Percent completed]@row), @cell<1)

Shadany

https://community.smartsheet.com/discussion/comment/359384#Comment_359384

Thank you Paul, the formula worked as it should. However it didn't work the way I wanted to. But now I have an idea on how to work with it. I appreciate your help!