- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 22, 2024 12:08 PM
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.
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2024 07:13 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2024 02:03 PM
Thank you @TheTimeSavingCo
