# Check off parent row when all children are checked

Options
✭✭✭✭✭

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.

• ✭✭✭✭✭
Options

It worked! thanks so much!

Can you write out what the formula is saying?

• ✭✭✭✭✭
Options

COOL! Thanks.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭✭✭✭
edited 01/04/21
Options

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!

• ✭✭✭✭✭✭
Options

@Rivky Emert Do you mean if ALL are blank?

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Try something like this...

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

• ✭✭✭✭✭
Options

That works, thanks!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• Options

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.

• ✭✭✭✭✭✭
Options

@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.

• Options

Ok, that makes sense.

Thank you very much!

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!