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

[Rafael_Salla_Paulilo]

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

[Jeff_Hager]

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.

[ThinhDinh]

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)

[Rafael_Salla_Paulilo]

Thanks, @ThinhDinh! Very smart solution!