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?

Genevieve P.

Hi @MarieM

If you are manually entering in contacts to the cells below, there isn't a way to make the formula auto-apply to Parent rows. This is because either you can have a formula in the cell OR you can manually make changes, but you can't do both.

What I would personally do is collapse all the Parent rows (right click on the column title > Collapse All) then drag-fill the formula down the Parent row cells.

Keep in mind that Contact type values cannot be combined together using a formula to output multiple contacts, so this will just show the Contact names as text values:

Cheers,
Genevieve