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

SLFoster

Thank you! I'll give it a try.