Pull data from other sheet.


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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!