Help

Formula to concat text from linked (or lookup) field WITH commas

Topic Labels: Formulas
1393 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Vincent_Ta
4 - Data Explorer
4 - Data Explorer

Hi everyone

I have a primary field that’s a formula, concatenating from other fields, date-name-contributor(s)

The contributors field is a linked field, and the formula relies on the lookup field “contributor last name”. So if the contributors column is “John Smith, Jane Doe” the lookup would show “Smith, Doe”. However, the formula will combine the last names without a comma, displaying “SmithDoe”. I’ve tried making a new formula field that takes from the lookup, but using that formula field in the primary field formula returns the same result.

Is there any way to get the data in a linked field to be used in a formula with comma formatting?

Thank you!

2 Replies 2

You need a rollup field instead of a lookup field. Use the following formula in the rollup.

ARRAYJOIN( values, ", ")

Hi Kuovonne,
great solution!

It works well with rollup of text field.
I tried using ARRAYJOIN( values, ", ") with a ROLLUP of formula field, but the result is #ERROR!

Is it a limitation or an unexpected behavior?

Thank you!