Help

Re: Looking to replicate a google formula table (COUNTIFs)

413 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Anxious
7 - App Architect
7 - App Architect

How would I go about duplicating this in some way in Airtable since each cell can’t have its own formula?

image
Cell formula: =COUNTIFS (Inventory!B8:B, "Tiny", Inventory!C8:C, "Head", Inventory!G8:G, "In Collection")

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
2 Replies 2

I think what youre looking for is the matrix app or rollup fields with conditions

I tried the rollup with conditions and couldn’t get it to work. I’ll do more research.

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)