Have Contact Field Always Display Smartsheet Contact Name
Due to form limitations, there are contacts that come into a Sheet displaying the email address in a contact column. The values are correctly aligned with existing Smartsheet contacts (i.e. if you hover over the email address, you see the full Smartsheet profile of the individual). What is the most efficient say to have these fields display the contact name instead of the email address and still remain connected to the Smartsheet contact profile?
Answers
-
Hi @Robert Mann
Do you always have the same number of contacts that you want your Form users to choose from?
If so, I would suggest setting these contacts as Values in the Column Properties. This will make sure the correct format (Contact Name with Email) appears in the Form dropdown menu to select. See Edit Dropdown column properties
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @Genevieve P. Yes, I did consider this approach, but the contact list is long and not entirely static - thus the need to capture email address to have the contact profile correctly matched in the sheet, and convert the field to the standard contact column name display.
-
Hi @Robert Mann
Thanks for clarifying! If the users are entering in email addresses, this will end up being the display value in the sheet, as you've found. The cells will still be able to be used in automated workflows and other contact scenarios, they will just display the email address instead of the name.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you - this was my first community question and I appreciate the quick response.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives