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.

Find more posts tagged with

Sheets

Formulas

functionality

Automations

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.