Sheet Summary to show most recent date for entry

Stacey Hughes

I have a sheet capturing many job names and I want to show the most recent date for a specific job and bring that into a dashboard. I was trying to create a sheet summary field but it isn't working, what am I doing wrong?

=Max(IF([Job Name]:{Job Name]="XYZ JOB",[Delivery Date]:[Delivery Date])))

markkrebs

=IF([job name]@row = "XYZ", MAX(COLLECT((Date:Date), [job name]:[job name], "XYZ")))

Paul Newcome

Give this a go:

=MAX(COLLECT([Delivery Date]:[Delivery Date], [Job Name]:[Job Name], @cell = "XYZ"))

markkrebs

=IF([job name]@row = "XYZ", MAX(COLLECT((Date:Date), [job name]:[job name], "XYZ")))

Paul Newcome

Give this a go:

=MAX(COLLECT([Delivery Date]:[Delivery Date], [Job Name]:[Job Name], @cell = "XYZ"))

Stacey Hughes

Community to the rescue, this worked and it is amazing —- thank you!!!!

Paul Newcome

Happy to help. 👍️