Skip to main content

Count how many times a row is linked in another table

  • March 25, 2023
  • 1 reply
  • 11 views

Forum|alt.badge.img+1

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

TheTimeSavingCo
Forum|alt.badge.img+31

Try using a Count field