Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to link values that include commas

Topic Labels: Formulas
261 1
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

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…