How to Join values from a reference sheet based on selections in a multi-select dropdown
Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell.
In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column next to it we want to collect the associated dollar values that correspond with each item.
Here is a very small example of the data source:
And here is where I am wanting to pull in the "Item - Value" column:
In an ideal scenario, the "Item Value" column would read: "Team Autographed Basketball - $4000, Autographed Jersey - $1200"
Let me know if there is any workaround here. I can't add any helper columns because the list is too long and the items change on a regular basis depending on who is currently on the team.
Best Answer
-
I would suggest:
=JOIN(COLLECT({Item - Value Column}, {Item Column}, HAS([Item Selection]@row, @cell)), CHAR(10))
Answers
-
The associated Item Values will be also formatted in the same way? As a multiselect dropdown?
-
I would suggest:
=JOIN(COLLECT({Item - Value Column}, {Item Column}, HAS([Item Selection]@row, @cell)), CHAR(10))
-
@L_123 correct. It would also be a multi-select dropdown.
-
@Paul Newcome THANK YOU! I can't believe that worked. I tried so many different iterations of that same formula with no luck.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!