I’m new to Airtable (and totally obsessed) and I know enough to be dangerous.
I’m certain there is an automated/quick way to rollup data from another table based on the criteria in one field… but I can.not.figure.it.out.
Table one has financial data with one record for each week. I have a Date field for “Week Ending,” and formula fields for Quarter and Year.
In Table Two, I want to have one record per Quarter with a Rollup/Count or something showing my totals from a field which I could then use for further formula fields.
I’ve got something kind of working (see pic) but surely there’s a better way! Help!