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