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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives