How to convert multiple email separated by commas from Text column to Contact list column?

I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON) and be able to send alerts. However, when I do that it just stays as text, not contacts.

Does anybody have any idea how I can fix this? or can we even use a formula to get those in the contact list? The funny part is that it works for single contacts, but it does not work with multiple contacts.

Find more posts tagged with

Sheets

Contacts

Formulas

Automations

Accepted answers

All comments

Itai Perez

Hi @PKafley

Can you share some screenshots to help me understand the issue a bit better?

How many emails are we talking about in the one cell?

PKafley

Hello @Itai,

I have 2 colums. One column is a text field(Double-text) were we will have 2 or more contacts that will be separated by comas. (ss below) and we have a formula in Contact List column(Double-contact List) to get those contacts from "Double-text" column. But seems like Multi contact list column does not like formula becasue it does not convert those emails from "Double-text" columns to contacts so that we can use it in automation.

Just trying to understand if there's any way we can convert those text emails to contacts.

Itai Perez

@PKafley

What formula are you using to seperate the email addresses?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.