Is it possible to use 'Group by' with 'List Collection' and order the groups in alphabetical order while ordering the lists by date?

Ask for Help
1

Is it possible to use ‘Group by’ with ‘List Collection’ and order the groups in alphabetical order while ordering the lists by date?

Captura de Tela 2024-11-01 às 08.58.42
Captura de Tela 2024-11-01 às 08.58.421920×958 96.3 KB

2

Try creating a query column that first sorts by date. Set the source of the collection to be the query. Then sort the collection by group. I know this hasn’t worked in some cases, but it might with a List collection.

3

An alternative is getting the numeric version of the first character in each group, then use it in a math formula in tandem with the date to get a final number to sort. Something like:

Group Num*10^5 + YEAR(D)*10^4 + MONTH(D)*10^2 + DAY(D)

4

Thanks, @ThinhDinh! Very smart solution!