How do I update Sheet 2 with data from Sheet 1 if it matches?

Sheryl Roland
Sheryl Roland ✭✭✭✭
edited 03/08/24 in Smartsheet Basics

In Sheet 1, users enter data via a form. In Sheet 2, I track the devices. I need the truck# from sheet 1 to populate on sheet 2 next to the name of the device. I also need the date that it was entered to populate on sheet 2 as well.

In sheet 1, ePCR Tablet, Navigator Number and CMED radio are separate columns, but in sheet 2, there is one column (Asset Name) with all devices listed.

Sheet 1

Sheet 2

I have racked my brain with =INDEX(COLLECT) and can't seem to get it right.

Thanks in advance!

Sheryl Roland