Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc.
How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list.
or do i need to create a different contact list/column? if so, how do I match the imported column to automatically generate the contact column with the same name?
Example:
Imported Column indicates: John Smith
Contact List Column to indicate: John Smith
Answers
-
Hello,
To import properly from excel to contact column in smartsheet you need email address which is more important then name so to properly have contacts in your excel the data should be: John Smith <john.smith@domain.com> or john.smith@domain.com
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives