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.
Answers
-
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?
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
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.
-
What formula are you using to seperate the email addresses?
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives