How to Join values from a reference sheet based on selections in a multi-select dropdown

KT_H

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.

Paul Newcome

I would suggest:

=JOIN(COLLECT({Item - Value Column}, {Item Column}, HAS([Item Selection]@row, @cell)), CHAR(10))

L_123

The associated Item Values will be also formatted in the same way? As a multiselect dropdown?

Paul Newcome

I would suggest:

=JOIN(COLLECT({Item - Value Column}, {Item Column}, HAS([Item Selection]@row, @cell)), CHAR(10))

KT_H

https://community.smartsheet.com/discussion/comment/378628#Comment_378628

@L_123 correct. It would also be a multi-select dropdown.

KT_H

https://community.smartsheet.com/discussion/comment/378646#Comment_378646

@Paul Newcome THANK YOU! I can't believe that worked. I tried so many different iterations of that same formula with no luck.

Paul Newcome

Happy to help. 👍️