How can I set a contact list column to display only the email and not the contact's name?
I often have to use lookup formulas between sheets where one sheet is a system export of information loaded into Smartsheet. The system obviously generates an email displaying as text. In a prior support call I was told to convert the column to a contact list and that has served me well.
I've created a Message Tool for Employee Appreciation Day and the web form allows text entry of an email that may not be in the contact list. To validate, I created a helper column to look up this value against the list of 15,000 possible choices. It works great unless the sheet recognizes the email and converts it to only display the name.
Thought I would attempt a Dynamic View to add instead. While it will most likely find a match in the DV interface, I can't be 100% certain. I was hoping to find a way to control the display using a function or setting to guarantee a successful automated send.
Help Article Resources
Check out the Formula Handbook template!