Getting user email address in smartsheet export
Hi-
I am still getting my sea legs with smartsheet. I have the need to be able to export the email addresses that each user has that has been entered into specific columns in the smartsheet, however, when I export the smart sheet I am only able to see the users name. Is there a way to export the email addresses (could be more than one in a cell within the column)?
Thank you in advance for any suggestions.
Dax
Answers
-
daisyq ✭✭
Maybe export to text file?
-
Kevin Smith ✭✭✭✭✭✭Hi
This may not work for you but I thought I would offer it. If the sheet is shared to everyone that has been entered into the column you refer to, and is in a workspace, you can get a nice export. Just right click on the workspace or the sheet/report, etc in the workspace and you will the the option at the bottom.
Thank you,
Kevin
Happy to help if I can.
☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an(Accepted Answer)
-
Dax67 ✭
dasiyq - on my corporate smartsheet, I do not see how I can export as text.
Kevin Smith - I am not sure I understand.
-
Kevin Smith ✭✭✭✭✭✭
Hi
When you are in the Browse mode and you right click on a Workspace or a sheet in a workspace, you get these options:
The one highlighted will give you the emails of everyone the workspace is shared with. This is not coming out of the sheet but rather the space and who is shared to the space. If, by chance, the column on the sheet is also who you have shared the space with, then you would be able to get all the emails even if you needed to filter some. There are not a lot of options to getting a list of email addresses but this one works rather well but is limited to just those who have the Workspace shared with them.
I hope that helps, however, often "Assigned To" or other Contact columns are not the made up of individuals who have the Workspace share to them. I would leave you with one more option, it doesn't solve your immediate problem butt for what you are looking for, I have set up a reference sheet which I can pull the email OR double check the email of someone in a contact field. It means setting up a sheet with Name, email, etc. but once you have that set up, you can do a few things to then capture the email address and include it for a number of purposes. If you want to know more about that, let me know.
Thank you,
Kevin
Happy to help if I can.
☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an(Accepted Answer)
-
Dax67 ✭
Kevin - Thanks. Will give it a shot. I appreciate the guidance.
Help Article Resources
Categories
Try this:<\/p>
=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), \"Less than 30 days from today\", \"More than 30 days from today\"), \"//www.santa-greenland.com/community/discussion/comment/328378/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":108267,"type":"question","name":"Combining IF Formula for Blank\/ Not Blank Cells","excerpt":"I want to create a formula that provides the below statuses: -Complete: Based on \"Collected Date\" not null -Incomplete: Based on \"Collected Date\" null and \"Antcipated Collected Date\" null -Pending: Based on \"Anticipated Collcted Date\" not null and \"Collected Date\" null Below is what I have, but it's unparseable:…","snippet":"I want to create a formula that provides the below statuses: -Complete: Based on \"Collected Date\" not null -Incomplete: Based on \"Collected Date\" null and \"Antcipated Collected…","categoryID":322,"dateInserted":"2023-07-28T17:23:40+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T18:28:47+00:00","insertUserID":164288,"insertUser":{"userID":164288,"name":"brownrobe","url":"https:\/\/community.smartsheet.com\/profile\/brownrobe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T18:42:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164288,"lastUser":{"userID":164288,"name":"brownrobe","url":"https:\/\/community.smartsheet.com\/profile\/brownrobe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T18:42:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":48,"score":null,"hot":3381135147,"url":"https:\/\/community.smartsheet.com\/discussion\/108267\/combining-if-formula-for-blank-not-blank-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108267\/combining-if-formula-for-blank-not-blank-cells","format":"Rich","lastPost":{"discussionID":108267,"commentID":387885,"name":"Re: Combining IF Formula for Blank\/ Not Blank Cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387885#Comment_387885","dateInserted":"2023-07-28T18:28:47+00:00","insertUserID":164288,"insertUser":{"userID":164288,"name":"brownrobe","url":"https:\/\/community.smartsheet.com\/profile\/brownrobe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T18:42:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T18:30:11+00:00","dateAnswered":"2023-07-28T18:22:11+00:00","acceptedAnswers":[{"commentID":387882,"body":"
