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