Help with Supply Inventory & Checkout Tracker

I made an inventory tracker to keep track of our supplies, and on a separate sheet I made a tracker for requests to check-out supplies and a form for this. I want people to be able to select multiple items on the form. The issue I am running into is that I had created a formula to pull the number we have “In Stock” from the inventory tracker sheet to populate the cell on the check-out request sheet based on what item they choose on the form, but the formula will not work when they select multiple items. Please see below screenshot to see the formula working for one item but not for multiple items.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!