Using an IF formula for Parents, Children rows
I'm currently trying to see if there's a formula that can be used to affect the parent row (row above the indented row) after a certain condition has been met within the children row (indented rows). Please see the image as a reference.
In this example I've set up, I'm trying to figure out if there's a formula that can help check the box on the CHILD row after all GRANDCHILD boxes below it have been checked off. I'm trying to figure out where the completion of boxes on the GRANDCHILD rows only affect the CHILD row above it and not the PARENT row or any of the other PARENT / CHILD / GRANDCHILD rows that are unrelated. I have yet to be able to come up with an IF formula for that process.
Is such a formula possible? I tried the DESCENDANTS / PARENT / CHILDREN functions to no avail.
For further information if necessary, in my actual project, the boxes in the GRANDCHILD rows have a formula that automatically check those boxes once certain conditions have been met. So I'm trying to figure out a formula that will then check the box in the CHILD row once all boxes in the GRANDCHILD row are checked off.
If such a formula is possible I would then want to expand it as my actual project, a PARENT row could have multiple CHILD rows beneath it and each CHILD row could have multiple GRANDCHILD rows beneath that. So I wanted to automate a way for those CHILD rows to be checked once their corresponding GRANDCHILD rows are checked, and once all corresponding CHILD rows are checked, the PARENT row will then be checked off.
Would anyone be able to help if they may know such a formula? Thank you in advance!!
Help Article Resources
Check out the Formula Handbook template!