Copying Contacts into a Smartsheet Contact Column

sblackmarr

When using the Salesforce Connector, there was an unintentional overwrite of cells in a contact column in my Smartsheet table. I have an exported file in Excel which has all the contact names (First and Last) that I could copy/paste into the Smartsheet contact column. I have tried copying this data in a group of column cells and individually. Result is a new contact being created in Smartsheet, not matching to the actual contact already in Smartsheet.

Previously, I made a copy of this Smartsheet which I have also tried to copy/paste from Smartsheet grid to Smartsheet grid. This time the result is first name_last name, and email address in <>.

Does anyone have an idea of how I can restore this column data to the previous state? I'm blocked trying to copy/paste the data in bulk from either an Excel sheet or a Smartsheet grid.

Courtney S.

Hopefully this past answer of mine for a similar question might help you:

Importing Emails of Users, Smartsheet Not Converting to Contact First and Last Name — Smartsheet Community