Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Edit Column Properties
Hi,
I have a spreadsheet to record building name, building manager and support staff assigned. Each row represent one building.
After I import excel to smartsheet, I try to change the column properties of building manager from text/number to contact list. However, on the screen, it requires me to enter name or email address (under Value-option).
Initially, I think smartsheet will connect with my outlook. Therefore, I do not need to type one by one.
However, I find out it does not work. I need to type email address of building manager one by one. May I ask is there any way can transfer outlook contact to Smartsheet contact....
Comments
-
Hi Peter,
You can bulk import contacts into Smartsheet that have been exported from Outlook as a .csv file (for more info, see: https://help.smartsheet.com/articles/796143-managing-contacts#bulkimport), but there isn't a way to have them all auto-fill in a contact column of a sheet.
Once they've been imported to your Smartsheet Contacts, contacts will be auto-suggested as you start typing in the cells of the Contact column.
-
Hi, Shaine:
May I ask one more question? You mentions that "contacts will be auto-suggested as you start typing in the cells of the Contact column.".
For my case, I have spreadsheet which has 600 rows building info . Each building was assigned one building manager. As I import to Smartsheet, the column of building manager I will set as Contact List.
Even I import outlook contact to smartsheet, I still need to rewrite the building manager column one by one, therefore, Smartsheet will auto fill the cell.
In spreadsheet, the name of building manager is Peter S. However, in my outlook contact, it will be Peter Smith. So, I should make sure name on excel column should match with name in outlook contact?
Thanks
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives