Pull data from other sheet.

Options

Hi, new to managing projects on Smartsheet. Current struggle: Sheet A and Sheet B have "Vehicle Identification Number" columns with unique values for each row.

Sheet A has an "Order ID" column, which lists the unique ID associated with the "Vehicle Identification Number" of the same row.

I need to create an "Order ID" column for Sheet B now, but I want it to auto-populate data in the Sheet A "Order ID' column, as long as the "Vehicle Identification Number" values matches in both sheets.

Not sure if this is simple or not, but everything I have tried has not worked. And I would be looking a ton of manual copy and pasting hours if nothing else works.

Thanks😅

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!