Email Contact Copy-pasting from Excel

Zsolt

Hi,

I have a contact column in Smartsheet. I can select any of the contacts and it displays the name of the person. Now, I have an Excel sheet with a column where emails are. Plain text. Same email that one of the contacts the sheet already has. When I copy the email address into the contact column in Smartsheet, here's what happens:

• The field shows the email address (instead of the person's name like usual)
• When I hover over the field, it does show the correct name and the same email address
• It treats the field as a different entry (different from another one where I select the same contact within Smartsheet), even the icon is different

How do I copy an email of a contact into Smartsheet so it recognizes the email and shows the name of the contact as normal rather than the email address?

Zsolt

Update... It does work with emails that do not have the plus sign. When you save the sheet it recognizes it. I was thinking it is supported because it allows me to add a contact with an email address including a plus sign (as you can see it in the screenshot).

Amber Eakin

Hello @Zsolt - You might need to edit the contacts in your "My Smartsheet Contacts" settings. You can edit their contact and input their first and last names so it displays properly.

https://help.smartsheet.com/articles/796143-managing-contacts#toc-edit-or-delete-contacts

Zsolt

The contact is fine. You can see it hovering over the cell. The plus sign completely throws off Smartsheet.