How to get email associated with Smartsheet user account

Scott Wadland

Hi folks, I have a sheet where I have a Name column which is a Contact List, and I need to have another column called Email which would contain the email address associated with the user account. If I format the Name column as Text, I can see the email address and I can parse it out, but if the Name column is formatted as a Contact List it does not work.

Any thoughts on how to do this?

SueinSpain

Sorry a couple of questions for clarity.

1. can you not use the Name column which is an email contact for emailing out? Why do you need a separate email address field? Is it to use in automation for a Notification or Update Request?
2. Alternatively - set up another lookup type smartsheet with the Account name and then email address associated with it and then use =INDEX(COLLECT to look up the email

I tend to have a text field for Name and a contact field for Email then for an automated update request I can send to the contents of a field Email and in the body of the email have the text …. Hi {{Name}} to fill in the person's name to address them by

Sorry if I've misunderstood your requirement but happy to help if I can

Scott Wadland

Hi Sue - the separate email field is so that I can use it in an INDEX/MATCH formula to pull in additional data which is sourced from our ERP - our Smartsheet user names do not match the ERP exactly, so email address is the only consistent piece of data.

If I understand your alternative, it would basically be to maintain a sheet with our account names and email addresses? I can see how that would work, but it would require additional ongoing maintenance.

Thanks,

Scott Wadland