Parent/Children Conditions

SLFoster

I'm new to Smartsheet and am trying to set up a regular monthly task list. I have certain "parent" tasks, and under each are a few sub-tasks or "Children". I have a checkbox to show that each line is complete. Is there a formula in the Parent row to check the box if all boxes are checked in the Children rows?

J. Craig Williams

SLFoster,

This is what I use:

=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), 1), 1, 0)

The first part 

COUNT(CHILDREN())

counts all the check boxes.

The second part

COUNTIF(CHILDREN(),1)

counts only the checked ones.

If they are equal, they are all checked.

Craig