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...

=INDEX({Sht_BUILDING_DATA-Bldg_Abbrv}, MATCH([PROJ BUILDING NAME]@row, {Sht_BUILDING_DATA-Bldg_Name}, 0))

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.

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a try...

=JOIN(COLLECT({Abbreviation Column}, {Building Name Column}, HAS([Proj Building Name]@row, @cell)), CHAR(10))

All comments

Paul Newcome

Give this a try...

=JOIN(COLLECT({Abbreviation Column}, {Building Name Column}, HAS([Proj Building Name]@row, @cell)), CHAR(10))

scott.95

Thank you, thank you. That worked.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.