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!

Find more posts tagged with

Formulas

Comments

Paul Newcome

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.

Maaik Meijerink

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 source-sheet is not the solution.

Example (dutch date-format):

[Planned dates]2:

01-03-2022

01-01-2022

13-12-2022

10-05-2022

01-05-2022

of course the desired result should be:

[Planned dates]2:

01-01-2022

01-03-2022

01-05-2022

10-05-2022

13-12-2022

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 work-around is way to much/heavy for such a small feature.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?