Contact List appearing as email address and not by name
Hello,
Has anyone encountered this issue? I have a contact list column and the values were entered with a name and an email, when pulling a value into a column sometimes it shows as a name (which is how we wanted to show) and other times as an email address, even for the same contact. This column's info is linked to a separate sheet, if that matters.... Thanks!
Best Answer
-
Yes if the link was broken that might cause it to be unable to lookup the name value.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Can you share more details about the column types that you are pulling these values into?
When I have Contacts listed in a "Contacts" column, they appear with the contact name only. When I copy a Contact into a text/number or date field, it shows as a "Name <emailaddress@email.com>" entry. When I copy a Contact into another Contact column, it again appears as a name.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@JReisman27 thanks for the input, this is the column type the values are pulling into:
Just as a note, in checking the cell l noticed the link is broken for one of the destination sheets these info is being used for (see below), l delete it this unknown sheet and not the cell is back to showing the name vs the email address. Would have been this the issue all along??
Thanks!
-
Yes if the link was broken that might cause it to be unable to lookup the name value.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!