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
-
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.
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"
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives