Help

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

Topic Labels: Formulas
631 1
cancel
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, ", ")
Labels