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? 😄