I'm pulling two excel sheets into SmartSheet. Sheet 1 is called the MASTERLIST Sheet 2 is Called the SALESFORM. The SALESFORM pulls data from the MASTERLIST.
What I want to happen is in the SALESFORM I enter an Item Number that is in the MASTERLIST and data from that row fills in in the specific spots.
Item Number / Item Description / Case Pack / Price / Duty Rate
These items have other details and formulas between them and dependent on them as well as columns for our Sales Team to fill in based on vendor.
How do I set up my sheet to be able to pull all this detail automatically when I put in the item number into the first column. Column titles are the same between sheets and my above example.
Thank You Much.