Sort data from a JOIN(COLLECT( formula within a cell
I have a formula in one of my sheets that looks out across multiple columns and populates the cell with all values present in the columns for that row. I simplified the column names to make it easier to read, but here is the formula:
=JOIN(COLLECT([Data1@row:Data5@row, Data1@row:Data5@row, <> ""), ", ")
My question: Is there a way to have this data sort itself in ascending order when it appears in the cell?
I haven't been able to find a way to do this so far and would love input on what I can try to make this work.
Thanks so much!
Comments

Unfortunately this is currently not possible, but it is a great idea. Feel free to Submit a Product Enhancement Request.
In the mean time, you would need to find a way to sort the data BEFORE joining it.

Any news about sorting within a cell with a formula ?
I already submitted this product Enhancement Request several times ...
For some goals I need to have dates from another sheet in a cell. No problem to get these, but sorting is no possible, so now I have them in order of appearance of the COLLECT formula. These data is entered randomly in different columns so first sorting them in the sourcesheet is not the solution.
Example (dutch dateformat):
[Planned dates]2:
01032022
01012022
13122022
10052022
01052022
of course the desired result should be:
[Planned dates]2:
01012022
01032022
01052022
10052022
13122022
to instantly see the order of dates, you have to look closely. With hundred of rows which get updated by this formula regurarly, I have to implement webhooks via an API. Which of course can be solved, but this workaround is way to much/heavy for such a small feature.
Help Article Resources
Categories
Check out the Formula Handbook template!