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

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!

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

ARRAYJOIN( values, ", ")

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.