Check Parent if All Children are Checked

Erik Hopfensperger

We use Smartsheet to house our product bill of materials across all projects. I would like to use a formula to populate in the parent row (sub-assembly) that would flip from an unchecked box to a checked box if all the children are checked. This is a parts received column so this would populate a report for our assembly team that a sub-assembly can be worked on since all the parts (children) are on site.

It would be a variation of this: =IF(COUNT(ANCESTORS()) > 0, 1, 0) but somehow I need to incorporate ALL ancestors and not just ANY ancestor is greater than 0. Any assistance is greatly appreciated.

Jason Tarpinian

For your parent checkbox cell, input this value (this is assuming your Primary column would always have a value)

=IF(COUNT(CHILDREN([Primary]@row)) = COUNTIFS(CHILDREN(), true), true)

Jason Tarpinian

For your parent checkbox cell, input this value (this is assuming your Primary column would always have a value)

=IF(COUNT(CHILDREN([Primary]@row)) = COUNTIFS(CHILDREN(), true), true)