- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 01, 2020 06:03 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2020 02:25 AM
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…