Function Removes Commas from Multi-Select Fields

#1

Hello! I’m attempting to concatenate two fields—both lookups from another table, one of which contains multi-select items separated by commas. When combining the fields via formula, the result strips out the comma separators from the multi-select field. However, if I use the formula only to display that multi-select field, the commas remain in place. How can I preserve that comma? Thanks!

0 Likes

#2

Resolved independently! The field is treated as an array; thus, I can apply array formulas.

0 Likes

#3

Hi William, I am having the same issue. Can you please elaborate on the fix. I tried ARRAYJOIN({Int Stakeholders/Staff Emails},{Paid Attendee Emails}) but I only get the comma in between the 3 fields.

0 Likes