Anyway to have parent automatically get checkmark?

Tyler Wymore

I have a parent row with 5 children rows. Is it possible to set my sheet up to have the parent row automatically get the checkmark after all the children rows have been checked off?

 

Example:

Is there anyway to have Project A auto check since objectives 1-5 are completed?

J. Craig Williams

Tyler,

 

Try this:

 

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

 

I hope this helps.

 

Craig

Tyler Wymore

The first formula "=IF(COUNT(CHILDREN())" gave me the error message "#MISSING"

 

The second formula "=COUNTIF(CHILDREN(), 1), 1, 0)" gave me the error message "#IMBALANCED"

J. Craig Williams

Sorry,

 

It isn't two formulas, it is one.

 

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

 

This part checks the number of checked boxes from the children

COUNTIF(CHILDREN(), 1)

 

This part counts the number of children (checked or unchecked)

COUNT(CHILDREN())

 

The equals sign in the middle determines if they match

 

=IF(expression,1,0)

 

will check the parent box if they do, uncheck if they don't.

 

Craig