Skip to main content

Hi there 🙂


I have a multiple select column (column A, not the primary key column) that includes values like:


Test A

Test B

Test, C


I use look up in another column to refer to column A. The output is:


Test A

Test B

“Test, C”


How can I display comma-containing records properly (without the quotation marks)? I found some references in this forum using roll-up instead of look-up, but that was not helpful for my case. Should I somehow parse it as a string first?

I found a work-around:


I changed the lookup column to a roll-up. Then I used


Substitute(arrayjoin(values), ‘"’,’’)


Found this workaround in another thread. Still wonder what would be the correct solution…


Reply