Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Counting Formula using Multiple Fields

Topic Labels: Formulas
359 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m not sure what the best way to describe this would be, but I hope this example table will get my question across. I am looking for a way to count up the number of Hat Tricks a Player gets automatically based on them having 3 or more Goals in a single Game. Each field of the same name is link across tables. The trouble I’m running into is that I’m limited to one field of reference (I need both Game and Player to be considered) when trying to use a Count function.

Any help would be appreciated.

RealHatTrick !RealHatTrick2
RealHatTrick3

0 Replies 0