How do I force Contact List to display emails (not names)

I have a Contact List column with emails and some appear with first and last names. Some are displayed as emails. When I overwrite them with just emails, the data shuttle overwrites them to names again. How do I make sure they stay as emails in a contact list?

The reason I would like them to display as emails is that I would like to copy and paste them later on to listservs etc, but still be able to use smartsheet automation to addressable emails for updates etc. Otherwise, I would keep the column as a text column.

Thanks for anything you may share.

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @gwson

What I would personally do here is map the emails to a Text column, as you noted. Then I would use a Column Formula to populate the Contact Column so I could use it for updates/alerts, etc.

You could Hide the Contacts Column if you don't want a duplicate column in your sheet. Would that work for you?

Cheers,

Genevieve

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.