JOIN using Children with Multi-Select Dropdown
Hi everyone,
I have a column in which the user selects the countries impacted from a drop-down list. More than one country can be selected. Now, I want to reflect all those countries in the child rows back to the parent row.
Easy enough, just use =JOIN(children()), right?
However, if I do this, it joins the information in the child rows together. If the child row has "Japan" and "South Korea" selected, JOIN(children()) will result in "JapanSouth Korea". Is there a certain delimiter I can use to tell it that these are two different values?
Answers
-
Hello @Regen
Yes, the Join function can include delimiters. You get to choose which one you like. Should you want the list to appear with line breaks as the delimiter, use CHAR(10) not enclosed in quotes. You must format the column as wrap-text to see the line break.
Kelly
-
Hi @Regen
I see you marked Kelly's answer as not resolving your issue. Have you tried adding in CHAR(10)?
Here's an example of the syntax:
=JOIN(CHILDREN(), CHAR(10))
Or you can use commas or other characters, but you'll want those in quotes:
=JOIN(CHILDREN(), ", ")
If this hasn't helped, it would be useful to see a screen capture and example of the formula you're using, but please block out sensitive data.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!