I’m new to Airtable and conditional formulas in general. I have a an airtable where I want to return a “Not Recently Scheduled” if a customer did not schedule an appointment with my company within the past 2 months, and “Recently scheduled” if they did. Previously scheduled appointments are recorded in another airtable, and I have added a lookup to this new table that pulls the dates of these previous appointments (if any) in a column called “Previous sessions”.
Does anyone know how to accomplish this? I have checked out a couple of instructions but I struggle to make it work. I haven’t found a guide where the formula only checks the most recent of several recorded dates, and I also haven’t figured out if I can check the last 2 months from the date in which a person checks the airtable, without having this date stated anywhere.
Let me know if it’s unclear what I try to accomplish and I’ll try to describe it in another way. Thank you!