I have contact records in my primary tab (we’re using Airtable as a CRM) where the contact’s Full Name is the main record. Then in another tab, we’re logging interactions with the contacts, and have a column that links to the contact record in the primary tab.
In our primary tab, we have a column “Follow Up Date” that looks at the interactions in the other tab and grabs the follow up dates from each interaction with that contact (also from the column “Follow Up Date”). Ideally though, we only want it to grab the most recent date. If you see in my below examples, the contact Brian has 2 dates in his follow up column. This is because there are 2 interactions linked to his contact, both of which have a follow up date. However, the only date we need is the June 3rd one, since it’s the most recent. Is there any way to add this as a condition? I’m not seeing it. Thanks!