@Rob_Warner, wondering if you've made more progress on this issue? Idk if Airtable had Multi-source syncing back in June 2020, but it might be something you can use (https://support.airtable.com/docs/multi-source-syncing). I don't like the idea of having to go to a different Base, but you can create a Synced table in the new Base and then add data (which comes in as additional records) from multiple tables in your original Base. You can choose what fields to bring in from each source/table. So you would maybe bring in Owner and Status for example.
Bonus: just noticed that you can then go your first Base, and create a Synced table and source it from the new Multi-source table in the new Base!!
Please let me know if this makes sense, or if, since 2020, you've found a better/different work around!
Why doesn't Airtable have a simple "Summary by User" button/table/view/extension!!? Beats me!
