How to pull latest date from a second sheet for a specific item

I'm trying to pull the latest date a certain site has been visited include that in summary sheet from second containing visits data. In secon sheet, specific can have multiple lines corresponding different vists. Any help with formulas do this would be greatly appreciated. Consider it your COVID-19 effort :).

Sheet one columns: Site name; Date of latest visit; etc.

A site has only one row in sheet 1

Sheet 2 columns: Site name; Date of visit; etc.

A site can have multiple rows in sheet 2


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!