In the 'View Options > Group by', the only sort options available are "Ascending" and "Descending".
Would be nice if we could sort the grouped rows by a value in another column.
An example would be like:
I have the columns [Date], [PersonName] and a virtual column [Date_PersonName], which has the formula below:
CONCATENATE([Date] , " - " , [PersonName])
I wish I could, in a View, group by [Date_PersonName] and sort this group (not the rows) by [Date], since the [Date_PersonName] virtual column is a text and it would sort alphabetticaly, not by the date itself.
This shouldn't be a problem using the date format 'YYYY-MM-DD', since sorting this alphabetically would have the desirable outcome, but sure it is a problem in any other format like 'DD-MM-YYYY'.
Example images bellow, Blue should be the first group to show if sorting ascending by date.