Retrieving the most recent date

[ccody]

Hello! I am creating a field for event attendees. I have each attendee's name, the events they attended, and the dates of the events they attended separated into 3 columns. I would like to make a fourth column that retrieves the most recent date each attendee came to an event. 

In this scenario, I want to make a fourth column that will automatically register that 1/8/24 is the most recent date and it will return that. Please let me know if you can help.

 

[TheTimeSavingCo]

Given the way you've structured your base you probably will need a script to help you do this

I recommend that you create a new table called "Event attendance" instead where each record represents a single person's attendance at a single event.  The fields in that table would be:
1. Event name
2. Event date
3. Linked field to a table where each record represents a single person

Once you've set your base up like that you can then use a rollup field on the 'Event date' field with the formula `MAX(values)` to get the most recent date

[ccody]

Thank you @TheTimeSavingCo