Airtable is really good for what it does : makes data-driven tools available for folks who don't want to mess with writing queries or being a DBA, and also has a reasonable API for automations.
For heavy stuff, I'll take Postgres anyday given the choice, but Airtable is great for small user-maintainable tools + dashboards, etc
Yes, but those formulas are scoped to the row, not the worksheet (you can't pass in a range of cells; each row essentially treats its own columns as local variables). SUM() means something completely different in Airtable than in every other spreadsheet out there. I've built out some beautiful Airtables only to find I had to switch to using Google sheets since I couldn't total up the value of a column, something I've been able to do since Lotus 123 in the 90s.
You can aggregate across multiple rows if you use a separate table to aggregate related records. I've done this for a small nonprofit to aggregate event registration data by year by linking the registration records to a new year table. Sounds kludgy, but it works.
For heavy stuff, I'll take Postgres anyday given the choice, but Airtable is great for small user-maintainable tools + dashboards, etc