Sort by collapsed fields

[Lisa_Wetherby]

I have a list of volunteers that, when I collapse all, clearly shows their hours for the year - see attached.

I would like to sort by this list in order to be able to see who had the most hours this year.

Is that possible? If not - how else can I aggregate the info to get what I need?

Thanks!

~Lisa

[ScottWorld]

Unfortunately, that is not possible. Airtable has given us no way to use summary values in any way whatsoever — we can't sort by them, we can't use them in automations, we can't use them in formulas, etc.

However, it looks like your hours are linked to another table, so you could get what you're looking for from the OTHER TABLE which your records are linked to. In your OTHER TABLE, you can create a ROLLUP FIELD which sums up the values from your hours table.

Your rollup field's formula would be:
SUM(values)

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld