How can I convert text names to existing contacts in my account?

I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my account already, but no luck.

I've done a lot of formatting to date since putting the data into Smartsheet so I don't want to have to re-upload the excel file.

I looked throughout the community, but couldn't find an exact answer to my issue.

Any ideas? Thanks in advance.

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Rpotashnik 

    Hope you are fine, if you have already a table contain the names and the Email for each of your contacts you can use Vlookup Or Index with Match to solve this problem.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"