I am trying to pull the date of departure for

Arjuna Quezada

I have a submission sheet where my users make entries through a Smartsheet's form to monitor shipments and then I have another sheet that's a summary sheet for each shipment. The submission sheet will have many rows all corresponding to the same shipment. I need a way to pull the Pickup date for a shipment from the submission sheet and input it into the summary sheet so that I can enter the shipment number into the first row and the pickup date for that shipment will show up in the correct row

This would be an example of the result I want:

This is what the submission sheet looks like:

Paul Newcome

Try this:

=MAX(COLLECT({Source Sheet Date Column}, {Source Sheet Shipment # Column}, @cell = [Shipment #]@row))

Paul Newcome

Try this:

=MAX(COLLECT({Source Sheet Date Column}, {Source Sheet Shipment # Column}, @cell = [Shipment #]@row))