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,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!