I have a long list of records that I have grouped by 2 fields (first by Week # single select and then by Start Day and Date Formula). I then want to sort so that all the records are in chronological order (sorted by Week #, then Start Day and Date Formula in chronological order)
I’m finding that the sort function is being applied within the smallest group (Start Day and Date Formula) in alpha order. I also am finding I can’t sort by a hidden field that is not a part of the grouped fields (for instance the original start time field). The big issue occurs when a week runs over two months that are not in alpha order (Week 39 spans September and October).
Is there a workaround here?
Appreciate any help or insight.