User Email in Column instead of Name
Is it possible to get the Smartsheet user email in a column in addition to or instead of the user name? I'd like to be able to do a lookup on the email address. The email address is relatively consistent among various applications and names are not consistent. (I did search, but since the changes to help and community were made, it seems impossible to find anything.)
Answers
-
Hi @ker9 ,
I'm curious whether someone knows of a way to extract the email address from a contact cell. I don't. I do have a workaround.
I use a helper sheet and vlookup. The helper sheet contains names and emails. I use the contact list cell in the main sheet to lookup the name in the helper sheet and return the email. This is easy if you only have a few contacts.
If you have lots of contacts or you're collecting input from people outside your circle then there is a more complicated workaround. If you move the row to the helper sheet it brings the email address with it. The column property for the contact in the helper sheet needs to be Text/Number, not Contact.
In the helper sheet, this formula will strip out the email from the text string. =MID([insert column name with contact]@row, FIND("<", [insert column name with contact]@row) + 1, LEN([insert column name with contact]@row) - FIND("<", [insert column name with contact]@row) - 1). I put this formula in a column [email] which can be a text/number or contact.
Then, use vlookup in your main sheet to return the email from your helper sheet.
Good luck. Hopefully someone has an easier answer and we can both learn.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi @Mark Cronk - thanks for your answer. I also have a look up sheet but we are a large organization and people are coming and going all the time so maintaining it is onerous.
I appreciate your response but I think I will leave this open in case someone else has another idea. :)
It would also be nice if you could export the User List directly to a sheet or overwrite an existing sheet with the data.
-
Hi Ker9,
I'll be following this for a better solution. Lots of smart users out there.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
It's unfortunate this is still outstanding/ lingering.
The use case I have is: I am using a form to collect information, that I then will use to drive an approval workflow.
A) when a user enters a form "Created By" is a system field that displays as Email address even if you require login for security
B) workflows require User Account's to drive approvals.
So, I am not able to systematically accept a form fill, use "created by" for security purposes, then translate that into a user account to execute a workflow.
Please let me either look up from email (Created by) to user account "contact" I can index & match off of, OR use a user account contact to provide an email I can index/match against. Ideally both directions would be best.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!