Airtable newbie here, if this question has a simple answer that I should be aware of please accept my apology and direct me to the right resource
I’m trying a simple operation that I feel should be possible. How do I count number of records in multiple linked tables based on input values?
I have a table called Projects. Projects can have a status based on a value from another linked table called Status (currently three different values are available in Status: planned, started, finished). Project are also assigned a region from another linked table called Region (currently: West, Central and East)
I want, in a fourth table called Results, count the number of projects with a certain “status” AND “region” combination. Is this possible? I’m foreseing that I have Region and Status as columns in Result and then countif in Projects based on the value in those two coulms.
Thanks a million