How do I Check/Uncheck Parent if at least 1 Child is checked?

SJM1609

I have been using this formula:

=IF(COUNTIFS(CHILDREN(), <>0), 1, 0) but if more that one child is checked in the column it comes up with #INVALID DATA TYPE .

How can i fix this. The requirement is at least one Child row must be checked for parent row to be true if not false.

SJM1609

Hi @Zachary Hall ,

Figured it out. Solution:

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

Thanks

Zachary Hall

@SJM1609 see if this works for you:

• =IF(CONTAINS(1, CHILDREN()), 1, 0)

SJM1609

Hi @Zachary Hall ,

Thanks for your response. This formula Unchecks the parent regardless of whether there is a check in the children column.

Are there any other solutions. Please see snippet for example of data.

Zachary Hall

Hi @SJM1609,

Sorry about that! I verified and it looks like the reason this doesn't work is due to the checkbox's boolean value because it works with strings, numbers, and even symbols. I am going to see if I can come up with another solution, but in the meantime welcome anyone who knows more to help!

SJM1609

Hi @Zachary Hall ,

Figured it out. Solution:

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

Thanks