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?