See the attached screenshot for an idea of what I’m trying to accomplish. I’m using a formula to concatenate the names of sellers and buyers. Simple except that if there are two or more names, how can I remove the identical last name, or add an & between names if they are different names?
This can be done using a single rollup field. Roll up the last name based on the {Linked to Contacts}, and use this aggregation formula:
IF(values, "Seller to " & ARRAYJOIN(ARRAYUNIQUE(values), " & "))
The ARRAYUNIQUE() function gets rid of duplicate last names, ARRAYJOIN() joins them with the ampersand, and the rest adds the prefix as long as there’s one incoming name.
This can be done using a single rollup field. Roll up the last name based on the {Linked to Contacts}, and use this aggregation formula:
IF(values, "Seller to " & ARRAYJOIN(ARRAYUNIQUE(values), " & "))
The ARRAYUNIQUE() function gets rid of duplicate last names, ARRAYJOIN() joins them with the ampersand, and the rest adds the prefix as long as there’s one incoming name.
Thank you so very much. This works perfectly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.