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?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives