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

Stéphane Charbonneau
edited 04/24/20 in Smartsheet Basics

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