Check off parent row when all children are checked

Automations 1

Hi,

I'm trying to type a formula that will check off the parent row, once all the children are checked off. I found the below formula in a different community post, however it's not working. Perhaps because the children are not in the primary column but in a different one?

=IF(COUNT(CHILDREN([Resident Name]2) = COUNTIF(CHILDREN(), 1), 1, 0))

Either way, I need a formula that will check off the parent once all the children are checked off. Also, please keep in mind, that all my parent rows have a different amount of children.

Snip.JPG

Paul Newcome

Try this...

=IF(COUNTIFS(CHILDREN(), 1) = COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)), 1)

Paul Newcome

If the count of the children that are checked equals the count of the children that are either checked or unchecked (gives total count), then check the box.

Paul Newcome

Try this...

=IF(COUNTIFS(CHILDREN(), 1) = COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)), 1)

Automations 1

It worked! thanks so much!

Can you write out what the formula is saying?

Paul Newcome

If the count of the children that are checked equals the count of the children that are either checked or unchecked (gives total count), then check the box.

Automations 1

COOL! Thanks.

Paul Newcome

Happy to help. 👍️

Automations 1

hi @Paul Newcome You once helped me with this formula. I have a similar situation and I'm hoping you can help me out again.

I have a column called "Start Date". I want to check off a box if the children of Start Date are blank. OR check it off if the children are NOT blank. Either way can work. Can you formulate that for me?

Thanks!

Paul Newcome

@Rivky Emert Do you mean if ALL are blank?

Automations 1

@Paul Newcome The scenario that I'm working on I actually need to know if at least one child is not blank.

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN([Start Date]@row), @cell = "") > 0, 1)

Automations 1

That works, thanks!

Paul Newcome

Happy to help. 👍️

Kari Leppälä

Hi!

I've tried using the formula that @Paul Newcome composed: =IF(COUNTIFS(CHILDREN(), 1) = COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)), 1)

This worked just fine until I tried to use the idea as a column formula. So I tried using nested IF: =IF((COUNT(CHILDREN(Title@row)) <> 0; IF(COUNTIFS(CHILDREN(); 1) = COUNTIFS(CHILDREN(); OR(@cell = 1; @cell <> 1)); 1); 0)

This is the best I've come up so far. Not all of my rows have children and at some point the check box got checked by default when creating a new row. It is not the only thing I've tried but I'm running out of ideas or I seem to not get the syntax right or what not.

Please help :)

Paul Newcome

@Kari Leppälä You won't be able to use a column formula because then you won't be able to manually check the boxes in the child rows. You would need to find a way to automate checking the child rows when they meet whatever criteria it is that you want.

Kari Leppälä

Ok, that makes sense.

Thank you very much!

Paul Newcome

@Kari Leppälä Happy to help. 👍️