Sign in to join the conversation:
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
Hi Khushboo,
See Shaine's response on this post: https://community.smartsheet.com/discussion/exporting-contact-emails-sheet-excel
I hope that helps!
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 orStep 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!
I'd like to accomplish this with a formula
I appreciate Khushboo's solution here, but I really think this should be a formula.
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
