How to calculate total percent completion only within rows that meet a specific criteria?

Barbara Silva

IT WORKED!!! Thank you SO SO much, @Paul Newcome! I REALLY appreciate it! :)

Paul Newcome

Happy to help! 👍️

My apologies for the previous mix up.

Barbara Silva

Hi @Paul Newcome, I have one last question if you could help. The formula currently being used in the helper column is:

=IF([Client Facing]@row = 1, IF(OR(COUNT(CHILDREN(Status@row)) = 0, COUNTIFS(CHILDREN([Client Facing]@row), 1) = 0), 1))

Which unchecks the parent row if immediate child rows are marked, but leaves parent rows checked if they are parents at a "2nd level" or higher. I tried playing with the "ancestors" formula, but could not figure it out. Is there a way to uncheck the parent if child rows - at any level - are checked (as client facing)?

Thank you once again.

Paul Newcome

Let's try changing the CHILDREN function to DESCENDANTS.

=IF([Client Facing]@row = 1, IF(OR(COUNT(DESCENDANTS(Status@row)) = 0, COUNTIFS(DESCENDANTS([Client Facing]@row), 1) = 0), 1))

Barbara Silva

Thank you, @Paul Newcome. You're the best!

Paul Newcome

Happy to help! 👍️