Retrieving the most recent date

201 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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. 

Screenshot 2024-05-22 at 12.06.15 PM.png

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.

2 Replies 2

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