Check a box in Parent cell based on children cells

M_L ✭✭✭✭✭


I need to check a box in a parent cell only when all children cells in that column have been checked. I will manually paste this formula into multiple parent cells in my sheet.

The formula I tried did not work...Any guidance or tips on where I went wrong?

My thought was if I gave the range of children cells, and said "when children are true (checked) return true (checked), else False (unchecked).

The desired outcome is to drive an automation based on when a parent cell is checked. I could also look into using the red, yellow, or green lights instead of checkboxes.

In that scenario I would want children to start out as Red, and turn Parent cell Green when all children are Green.

Thanks in advance for the help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!