Name and Email in a Contact Column

aschneiderheinze1025

I have a contact column called [Program Manager].

First, I noticed that if I map this column to a form field in a fillable PDF, it shows the email address, not the name. So, I created a helper column called [Program Manager (Name)] that extracts the name and use it in my PDF. Not the PDF shows the Program Manager's name in one field and the email address in the other.

Second, I noticed that if I use this {{Program Manager}} in the message of an automated notification, it shows the name, not the email address. So, by including [Program Manager (Name)] and [Program Manager], I get the Program Manager's name twice.

I have tried different ways to extract the email address in a new helper column [Program Manager (Email)], but I can't get it to work.

What should I do within the text of an automated notification to get the email address to show, to accompany the Program Manager's name?

SSFeatures

Hi @aschneiderheinze1025, unfortunately there isn't a good solution to this problem at the moment.

First, you can up vote this feature request, to help the Smartsheet team prioritize this issue.

Next, in this thread Darren Mullen describes a workaround by creating a duplicate contact column, and then changing the column type to "Text/Number", which will then show the names and the email addresses in the cells. However, if you add new program managers into your sheet, their emails will not be automatically added into this column, and you will need to manually recreate the column again.

Last, in this thread DKazatsky2 describes a workaround using automations, but it's pretty complex and requires bouncing the data between two different sheets.

I hope this helps!