Join Distinct Collect Children Formula

Kal

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

Kelly Moore

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

Kelly Moore

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

Yes, the Formula Worked. Thanks @Kelly Moore