Have a cell's content be based from a multi-select dropdown

Hi, I might be overthinking this, but after reading several posts, I can't find what I'm looking for. I have a multi-select column that denotes buildings where I have projects. I want another column next to that that populates the building's abbreviation(s) from the multi-select dropdown. For a single building, using...


works just fine. When I have 2 or more buildings selected in the dropdown, I get #NO MATCH. The Index/Match formula pulls from another sheet where each building has a row with a name column and abbreviation column.

My attempts at join/collect and HAS haven't proven successful. Any help is appreciated. The building abbreviation is to help with a report to keep the columns narrow.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!