Pulling Purchase price from a master sheet

yusiboyz ✭✭
edited 10/05/22 in Formulas and Functions

Hey All,

I have a master sheet where I input items that I purchased and it's price. To identify a product I use SKU's for each Product.

Now every two weeks I pull my sales and import it to a new smart sheet. The I copy the sku and go into my master sheet and find it there and look at how much I paid for it, then I got back to the import and paste the purchase price.

Is there a way to have this automated? Can it go to the master sheet and look for the SKU then see how much I paid for it and come back and paste it?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!