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 information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives