Join Distinct Collect Children Formula

Smartsheet Community:

I am Using this Formula to Collect Information in Child Cells:=JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), ", ")

However, I would like the Numbers in Chronological Order (i.e. S16, S17, S18). Is there a way to Modify the Formula so it does that? See Screenshot Below

Thanks


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Kal

    If you want the values to appear to be in numerical order within that cell, potentially there is a way.

    If you can modify your column type, if not already, to a multiselect column and use a line-break as your delimiter, the values will automatically appear in numerical order. The value for a line break is CHAR(10).

    =JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), CHAR(10))

    If you format the column as wrapped and make the column skinny, all the values will stack up to make the order even more visible.

    Would this work for you?

    Kelly

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Kal

    If you want the values to appear to be in numerical order within that cell, potentially there is a way.

    If you can modify your column type, if not already, to a multiselect column and use a line-break as your delimiter, the values will automatically appear in numerical order. The value for a line break is CHAR(10).

    =JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), CHAR(10))

    If you format the column as wrapped and make the column skinny, all the values will stack up to make the order even more visible.

    Would this work for you?

    Kelly

  • Kal
    Kal ✭✭

    Yes, the Formula Worked. Thanks @Kelly Moore

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!