what is the best way to combine contacts from children rows into parent row?

MarieM

In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)

BullandKhmer

=JOIN(CHILDREN(), CHAR(10))

MarieM

Thank you! How would I apply this to all parent rows and newly added rows?