
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2021 08:48 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2021 09:05 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2021 09:05 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2021 01:31 PM
Thank you so very much. This works perfectly.
