Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

894 0
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anxious
7 - App Architect
7 - App Architect
See Solution in Thread

‎Oct 11, 2021 01:12 PM

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)
0 Kudos
Reply
2 Replies 2
Rebecca_Elam
9 - Sun
9 - Sun
See Solution in Thread

‎Oct 11, 2021 02:40 PM

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

0 Kudos
Reply
Anxious
7 - App Architect
7 - App Architect
In response to Rebecca_Elam
See Solution in Thread

‎Oct 11, 2021 05:26 PM

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)
0 Kudos
Reply
Copyright © 2025 Khoros, LLC