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
Best Answer
-
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!
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!
-
Thank you @kowal !
-
Always a pleasure!
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives