Group By text and sort by date

AppSheet AppSheet Q&A
10

If you are OK with adding an index at the head of the string, then here is another idea.

Create a VC using the INDEXOF() technique by @Steve (described here), something like

"[" 
& COUNT(
  SPLIT(
    ANY(
      SPLIT(
        (" , " & SORT(SELECT(ORDERS[order.date],TRUE,TRUE)) & " , "),
        (" , " & [order.date] & " , ")
      )
    ),
    " , "
  )
)
& "]: " 
& SWITCH(
[order.date],
TODAY(), "TODAY - ",
TODAY() + 1, "Tomorrow - ",
""
)
& TEXT([order.date],"D MMM")

to be used as a grouping column.

Then you get a table view something like this. (adding formats would also help users, I suppose)

image
image495×512 31.4 KB

Note. The computation of the VC seems a bit heavy, so test it well and make sure you have a good housekeeping process in place.

3 Likes