how do I convert email addresses to only names under Owner field ?
The Owner field in my Smartsheet I inherited from another user contains a mix of names and emails. When I execute the drop-down under Owner, the names entered in my Smartsheet Contact list are not visible, only the associated email. My preference is to list only the names, not the email addresses, in the Owner field. Thanks Steve
Best Answer
-
Contact Columns will remember what values have been selected previously and show that in a dropdown menu. This means if there's a cell with the email address only, this email will appear as an option.
To change this, you can add your users with Names to the Contact Column Properties to make sure they're the ones seen in the dropdown list, first. See: Manage which contacts appear when you type in a cell
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Contact Columns will remember what values have been selected previously and show that in a dropdown menu. This means if there's a cell with the email address only, this email will appear as an option.
To change this, you can add your users with Names to the Contact Column Properties to make sure they're the ones seen in the dropdown list, first. See: Manage which contacts appear when you type in a cell
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you Genevieve - problem solved !
Help Article Resources
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
Check out the Formula Handbook template!