Updating parent row with data from all children rows

Becky Wilson

I am trying to update a parent row with the data found in the children rows

The following formula works

=[Check Number]2 + "," + [Check Number]3

however, I have some parent rows that have more than 2 children beneath them

Is there a formula to use the parent/child relationship to get it to include all data from the children regardless of how many there are?

Jon Mark H

Hey @Becky Wilson !

Are you using this formula in the parent row for [Check Number]?

I recommend using this formula:

=IF(COUNT(CHILDREN([Check Number]@row)) > 0, JOIN(DESCENDANTS([Check Number]@row), ","), "")

It double checks that you have children of that row, and eliminates errors if you do NOT have children there. If you DO have children, it will put them in the parent cell w/ "," separating each of them.

Let me know if that fixes you issue and if you have any other problems you need solved!

-Jon Mark

Becky Wilson

Thanks Jon! That worked.

Jon Mark H

Hey @Becky Wilson !

Are you using this formula in the parent row for [Check Number]?

I recommend using this formula:

=IF(COUNT(CHILDREN([Check Number]@row)) > 0, JOIN(DESCENDANTS([Check Number]@row), ","), "")

It double checks that you have children of that row, and eliminates errors if you do NOT have children there. If you DO have children, it will put them in the parent cell w/ "," separating each of them.

Let me know if that fixes you issue and if you have any other problems you need solved!

-Jon Mark

Becky Wilson

Thanks Jon! That worked.

Jon Mark H

You're very welcome! Glad it helped!