Concat children item and sum it up in the parent item
So I have a list of sub items that I would like to combine in the top row.
For example, let's say we have sub items:
Red
Blue
Green
Yellow
I want this to roll up for my top (parent) cell and have it as: Red; Blue; Green; Yellow
Thanks!
Best Answer
-
Hi @James.son
I believe the Join function is what you're looking for. More information here https://help.smartsheet.com/function/join
Basic Formula would look like this: =JOIN(CHILDREN([Primary Column]2:[Primary Column]6), " , ")
With " , " being the separator
between the different items.
Answers
-
Hi @James.son
I believe the Join function is what you're looking for. More information here https://help.smartsheet.com/function/join
Basic Formula would look like this: =JOIN(CHILDREN([Primary Column]2:[Primary Column]6), " , ")
With " , " being the separator
between the different items.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!