Skip to main content

I have a table organized by educator name. I’m trying to create a column that pulls the FIRST occurrence of coaching from a separate base, so we can see on what day each teacher had their first meeting with their instructional coach. The dates vary widely, so I’m not sure how to write this formula.


Each coaching session has a unique ID: “DCoach Name] NTeacher Name] NType of Meeting] tDate]”. I’m hoping that it’s possible to write a formula that can find all of the unique IDs for a particular teacher, and then show me just the oldest one (which would be the first in the school year).


I’m a pretty new user of Airtable, so thanks for your patience with what may be a basic question 🙂

Hi @Virginia_McManus


Welcome to Airtable Community !


I need to see the structure of your base to give a better answer.


But if your base has a table for the coaching sessions that is linked to the instructor, then this is very easy. You just need to create a Rollup Field in the Instructor table to get the Min(Values) of the Date Field

That worked great! Thank you so much for your help; I really appreciate it.

That worked great! Thank you so much for your help; I really appreciate it.


Glad it worked 🙂 Can you please mark it as Solution?

Glad it worked 🙂 Can you please mark it as Solution?


I hadn’t noticed that feature before - thanks for the nudge 🙂.

Reply


Terms & Conditions