Display Contact Name instead of full email

Steven Deem

Hi everyone,

Thank you for your time looking at this, I appreciate all the help and guidance I've received in this forum.

Ok, here's my situation. I have an intake form and one of the entries is for the submitters name. The Field Setting is set to a Contact. After submitting the form, their name they typed in would appear in the Contact field, not looking like an actual Contact. This happened with every persons entry and looked like this:

I had to go back in after they submitted the form and manually update the cell to be an actual Contact so then it would look like this:

I did some research and read a lot of posts in the help section here and tried out changing the field on the Form to have them type in their email address instead of their name with the hopes of Smartsheet finding them via their email address and then populating the cell with their contact like the picture above. Instead, what I get is now this:

So my question is, is there any way to have Smartsheet automatically fill in a cell like the second picture where it just the submitters name with their contact information already stored in it based on type of entry, helper column, workflow or anything?

It appears that Smartsheet references my company's very large directory as every person whether submitter, stakeholder or assignee pulls up in a contact cell, I just have to manually type in their first name (often their middle initial) and the displayed contact choices dwindle down until I see the person I'm looking for and select them.

Thank you in advance!

More information:

The second picture does contain all of my company information and does the same for anyone once I update the cell to their actual contact. It looks like this when it is hovered over:

Thank you

Humashankar

Hi @Steven Deem

To your use case displaying contact names in your intake form

There are few similar discussions and solutions offered and here are some for your reference, can you take a look and see if that helps for you or not.

How to show Contact Names instead of email addresses in Contact Column in Sheet? — Smartsheet Community

Contact list displays email instead of name — Smartsheet Community

Hope this helps - Happy to help further!!

Thank you very much and have a great one!

Warm regards