Count how many times a row is linked in another table

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

Hi everyone!

I'm new to Airtable so I need a bit of help.

I have two bases with one main table named the same. "Students" and "Mentors"

The "Mentors" base is published as a sync table in the "Students" base, and vice-versa.

In the "Students" base, I have a list of students, and each row has an associated "Mentor" from the Mentors base.

Now, on the "Mentors" base, I'm trying to count how many students each mentor is assigned to.

I imagine I might need to use a formula, but that's beyond what I know how to do.

Help? 😄 

1 Reply 1