Joining a text field with a multi-select field

I have a sheet where a unique ID field is created by joining two columns. Originally they were both text columns but one of the columns changed to a multi-select column. The issue that we're having is that when more than one option is selected in the multi-select column, it's causing the resulting text in the unique ID field to not be recognizable in the index/match formula we're using on a different sheet. We tested it by pasting plain text over the cell in question and the other sheet was able to pull in the information correctly. Also, all of the rows where only one option is selected in the multi-select weren't causing any issues. Has anyone else experienced this? Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!