Thanks Jeremy, that’s great. Turns out you can’t actually group by a formula field, who knew? I just duplicated it and turned it into a regular number field. Check it out: Screencast.com Sorting_airtable.swf Shared from ...

Well thank you, this does appear to work so long as I do not group the items. As soon as I do that, it takes over any sorting. Sorting is then done within each group and the totals are “ignored”.

Thanks, I did try it and it was very interesting to see the Rollups at work. Unless I did something wrong, your method essentially seems to tally up how many competitors are in each school. That last function then adds that total number of competitor...

Wow thank you so much for your response @Jeremy_Oglesby , that’s amazing! I could be mistaken, but unfortunately I don’t think that works for me because my table is built around competitors, not schools. The screen shot I sent is a specific view of m...

I have a similar issue where I would like to sort groups based on their summary statistics. Is there any way to do that? I don’t think the above suggestion works in my case. The sorting only seems to act on the individual rows, which is nice but does...