LOOKUP addresses and format as CONTACTS

I have a working formula

=JOIN(COLLECT({EMAIL}, {AGENCY}, Agency@row), CHAR(10))

This gives me all the emails for an agency in a single cell, with a return between each address.

I need to transfer the grouped emails to another sheet in a CONTACT COLUMN and have them recognised as contacts so that I can set a filter in Dynamic View based on that content.

Doing a VLOOKUP between the sheets only brings in the addresses; it does not have them recognised as contacts.

Any advice would be greatly appreciated.

Find more posts tagged with

Formulas

Dynamic View

Filters

Accepted answers

jmyzk_cloudsmart_jp

Hi @22Wordsmith

Please review the following related discussions on creating multiple contacts.

https://community.smartsheet.com/discussion/comment/477019#Comment_477019

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column

All comments

jmyzk_cloudsmart_jp

Hi @22Wordsmith

Please review the following related discussions on creating multiple contacts.

https://community.smartsheet.com/discussion/comment/477019#Comment_477019

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column

22Wordsmith

Thanks. I had to use the Data Shuttle solution for agency reasons. There are 13 entries where the agency matches what is in the file to be uploaded.

The upload only entered email addresses (as contacts, yay) for the first entry. Any thoughts on why it is not completing the other 12 rows?

jmyzk_cloudsmart_jp

Most common reason:
Your unique identifier (e.g., Autonumber or ID column) used in the Merge > Update only mapping might not match exactly between the uploaded file and the target sheet. If only one ID matches (the first row), only that row will update.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.