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.
Best Answer
-
Give this a try...
=JOIN(COLLECT({Abbreviation Column}, {Building Name Column}, HAS([Proj Building Name]@row, @cell)), CHAR(10))
Answers
-
Give this a try...
=JOIN(COLLECT({Abbreviation Column}, {Building Name Column}, HAS([Proj Building Name]@row, @cell)), CHAR(10))
-
Thank you, thank you. That worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!