Inventory Sheet Evaluating - Locations in Multi Select Column


On my inventory sheet I have a list of items in rows. For each row-item I have a column with a multiple-select to identify how many locations have that item.

On a separate sheet, I'd like to be able to type a location and populate all the rows of inventory items that live at that location.

Any advice on which formula to use to accomplish this function?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!