Count linked records over multiple fields in the same table

Topic Labels: Formulas
1825 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

The Count field lets you count the number of linked records.

For example, take the screenshot below

Line 8, I want the count field to count the number of linked records in Team 1-4 and then add them up.

Is there a way to do this?

Seems like this should be easy but may have reached the limit of Airtable.

This is essential to the business use case I want to get Airtable for my organisation.

Any work arounds are appreicated too.!

3 Replies 3
4 - Data Explorer
4 - Data Explorer

Airtable wont let me add a picture

So a brief description

Total field followed by Team 1 Team 2 Team 3 Team 4

Each of the team fields are linked to a record on another table.

I want to the Total field to count the linked records in each column Team 1-4, and add it up. Count field only lets you count one field not others

Hi @Hiteshree_Ruparell - workaround here would be to add a count field for each linked field, then make your total field a formula which adds the count fields. You can hide the 4 count fields if you don’t want to see these in your view.


4 - Data Explorer
4 - Data Explorer

How about if you have the same teams linked in multiple fields. It would count them twice. Is there a way of counting unique linked records across fields?