JOINING Contacts from Children rows to Parent
Hi. I have active contacts from my contact list in Children row. I would like to bring them together in one cell in parent row. I understand function COLLECT needs to be used with another function. If it is JOIN, then it lists me all the names but they are not active contacts anymore. Is there a possibility to keep them active in Parent row?
Best Answer
-
There is currently no way to use a formula to output multiple usable contacts within a single cell even if the box in the column properties is checked to allow multiple contacts. Unfortunately what you are wanting would have to be manual entry on the parent row level.
Answers
-
There is currently no way to use a formula to output multiple usable contacts within a single cell even if the box in the column properties is checked to allow multiple contacts. Unfortunately what you are wanting would have to be manual entry on the parent row level.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives