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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you Genevieve - problem solved !
Help Article Resources
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
Check out the Formula Handbook template!