Quick way to convert text to Contact List items
Hello. I'm working on importing resource allocation data from an external source into Smartsheet. This includes thousands of rows of data, including a column of employees names in text form. Is there a quick way to convert an employee's name from text to their name from our Contact List (so it appears in the Resource View)? Find/Replace doesn't seem to allow replacing with a Contact List item. Thanks!
Answers
-
Hi Madeline,
Find and Replace should work, you would just need to make sure the column is a Contact List type of column. Here's another thread where I show how to use the Find and Replace with contacts: https://community.smartsheet.com/discussion/comment/244867#Comment_244867
As another option, would it be possible to import their email addresses instead of names?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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