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

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

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.

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