How to import data from other sheets?

Mycelus ✭✭
edited 06/15/22 in Formulas and Functions

Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc.

I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is:

Item Sheet: select SKU-001

Sheet references database for SKU-001, and fills in the Manufacturer, Item Name, Model #, Item Category, etc.

How would I go about achieving this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!