Skip to main content

Hi there :slightly_smiling_face:

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…