Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

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

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!

1 Reply 1

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

ARRAYJOIN( values, ", ")