SupplyChain ✭✭
edited 12/09/19 in Smartsheet Basics


I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email sent to an email address other than the user submitting the form. To my knowledge these aren't quite an option, so the solutions I've found lead me to the following:

When filling out the form, since there's no auto-fill based on other entries to a unique identifier (ie: if Item Description entered is "1-1/2" BIT", then Item Number auto-fills with B15), it makes the most sense to have someone search/order by item name rather than item number. 

So, I want to include the Item# in the form results with a formula. Originally I was going to do a VLOOKUP, but realized the Item Number is to the left of the ITEM DESCRIPTION in the master table. 

In short, I need to figure out how to do an INDEX/MATCH to another sheet to use the ITEM DESCRIPTION to retrieve the corresponding ITEM NUMBER. 

Thank you in advance for your time and expertise!


Form View.jpg

Item Master View.jpg