Formula to work with different levels of Hierarchies
I'm currently trying to figure out a formula that would help with collecting results from a certain column and only when those results are all "true", can the Child row (of the same column) be marked as "true" (without affecting other parent/child/grandchild rows of the same column).
Here is an image of what I'm trying to get at. Basically a formula where the checkbox of column 2 for the Child row will automatically check itself once the grandchild rows indented below it have all of their boxes checked in column 2. However, the formula needs to only look at the grandchild rows of that specific child row and not go beyond it.
I've tried working with CHILDREN function, DESCENDANTS function, etc, but I have not figured out how to make it more "autonomous". What I mean by autonomous is a formula that could automatically check for the boxes in column 2 regardless of how many grandchild rows there may be underneath the child row. I thought it could be better than having to manually select the range of grandchild rows beneath the child row each time a new set of Parent/Child/Grandchild rows are created for my project.
Is such a formula possible on smartsheet as of currently?
Help Article Resources
Check out the Formula Handbook template!