Extract Email Address Only from Contact List Column Upon Export into a Spread Sheet

Hi,

In reference, to the above subject, I would need an help to view or extract only Email address from the Contact List column when I export the Smartsheet sheet to Excel spreadsheet.

Thanks!

Khushboo

Find more posts tagged with

Formulas

Email Notifications

Comments

Alejandra

Hi Khushboo,

See Shaine's response on this post: https://community.smartsheet.com/discussion/exporting-contact-emails-sheet-excel

I hope that helps!

@khush_hello

Hi Alejandra,

Thanks for your response. But I believe I found a solution too!

This might not be the only solution but it works.

Step 1a: Create a save as copy of existing sheet that you wish to download

or

Step 1b: Convert the sheet contact list column to a text/numeric column; bingo!

(Note: Don't forget to convert it back to Contact List type]

Step 2: If Step 1a is followed then convert the "Contact List" column to a text/numeric column; bingo!

Step 3a: If Step 1a is followed then download the Smartsheet file and use excel based formulae to extract email address, within [abc <abc@abcxyzefg.com>]

Formulae: [=MID(A1, FIND("<", A1) + 1, FIND(">", A1) - FIND("<", A1) - 1) ]

or

Step 3b: If Step 1b is followed then use below Smartsheet formulae to extract email address on Smartsheet another column (type text/numeric):

[=MID(ContactList@row, FIND("<", ContactList@row) + 1, FIND(">", ContactList@row) - FIND("<", ContactList@row) - 1) ]

Step 4: Job done!

Please let me know how it goes.

Cheers!

Khushboo

JeremiahHorstick

I'd like to accomplish this with a formula

ro.fei

I appreciate Khushboo's solution here, but I really think this should be a formula.

Sign in to join the conversation!

Quick Links

Trending discussions

Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
Multiple conditions for counting
Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client. =COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell )) But this comes up as unparseable. Where am I going wrong?
Editing Sheet Summary 'CY' Current Year - so my formulas update
I am attempting to enter the CY - Current Year into my sheet summary so I don't have to go through and update every cell formula when creating the new year's metrix sheets. What is the correct syntax in my formula so both CY are pink, indicating it references the CY in the Sheet Summary?