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?

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

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.

https://help.smartsheet.com/function/join

Kelly

Genevieve P.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.