Challenge with Last Date calculation using Lookup

[Victor_Bohbot]

Hi there,

I hope you’re well. I’m facing what I think is a challenging issue and am looking for assistance or brainstorming. I have a table with all the trainings, and each training has multiple dates. These dates can be updated in any order (e.g., I can create a training date today for the 15th of October 2024, and tomorrow for the 19th of September 2024). I want to determine when the last training date is forecasted.

I’ve tried retrieving all dates using a LOOKUP value and creating a new column named “Last Date,” but it only works when the latest added training date matches the actual last training date. I’ve attached a screenshot for better understanding of my issue.

I was thinking of using a FILTER with my LOOKUP but still haven’t found a solution. Perhaps there’s another approach I could take.

Thank you for your help.

Cheers,
Victor

[Jeff_Hager]

Just use a Rollup Max instead of a Lookup and Single Value column.

[Victor_Bohbot]

It’s working, thank you so much! I was too insistent on using the LOOKUP value.