what is the best way to combine contacts from children rows into parent row?
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)
Answers
-
=JOIN(CHILDREN(), CHAR(10))
-
Thank you! How would I apply this to all parent rows and newly added rows?
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!