Help with Supply Inventory & Checkout Tracker

erika_j

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.

BullandKhmer

How many unique items do you have in inventory?

Andrée Starå

Hi @erika_j

I hope you're well and safe!

How many items would they need to be able to select for check-out?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!