Skip to main content

Looking to replicate a google formula table (COUNTIFs)

  • October 11, 2021
  • 2 replies
  • 34 views
A
Forum|alt.badge.img+9

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


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

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

    2 replies

    R
    Forum|alt.badge.img+4
    • Rebecca_Elam
    • Inspiring
    • October 11, 2021

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

    A
    Forum|alt.badge.img+9
    • Anxious
    • Author
    • Inspiring
    • October 12, 2021

    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 PlanRecords: 1,200/1,200 1000/1000 (I might have to find a different solution soon)Automation Runs: ??/100Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
    Terms & ConditionsAccessibility statement