Hey guys, hoping I can get some guidance on making a smarter order form for my admin folks.
I created an inventory sheet for everything we have, and I'd like to make another sheet that, when a column is filled with the products' Inventory ID numbers, the next column automatically populates with the price of the product that's listed on the inventory sheet. Additionally, I'd like a column that, when a "Quantity" column is filled, is automatically populated with the price of the total quantity ordered.
Thanks for taking the time to read this. I'd be happy to clarify anything.
Bookmarks