Welcome!

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

INDEX formula to get the text in the next row in a different column
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
Additional Condition (Formula)
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
Formula to determine number of plants still in inventory which were acquired more than 6 months ago
Good day, I have a native plant nursery, and I am looking to determine the number of plants that are still in the inventory and which were acquired 6 months ago or more. So, a rolling SUMIFS maybe? Wanting to do this in the sheet summary, but open to other solutions that I can display in the project's dashboard.