JOIN using Children with Multi-Select Dropdown

Options

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

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!