Lookup contact name from email address
Hi,
Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address.
I'm aware that I could achieve something similar by have a second sheet with Names and email addresses. However, this would be duplication of data.
Answers
-
If you set your Contact List to Allow Multiple Contacts per cell and check them all off then they would all be listed at once.
In another column, you can add a formula to Find the Created By within your Contact List.
=IF(FIND([Created By]@row, [Contact List]@row) > 0, "Existing Contact", "New")
Tested it on my end and it worked.
-
Hi Nick,
I appreciate the suggestion. Unfortunately this doesn't meet my requirements. I'm attempting to minimize duplicate entry as this minimize errors.
As I already have the email address I really should be able to lookup against the contact list. I suspect this is a feature request.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!