Pre Populated Form Fields

I want to create an order request form with an inventory control sheet I've created.

The sheet contains remaining stock on hand of several different items.

The drop down list will contain the items I have in stock, but I'd like to have the amount available to show up based on the item selected.

This number would be available in a cell in the worksheet.

Any thoughts?






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!