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.