Formula to combine Name and email to create a contact row

Hi Christine,

As you've found, that formula would join the content together but the Contact List type of column won't be able to recognize what the name is and what the email is. There currently isn't a way for a formula to create contacts in the way you're looking to do (associating a name and an email together for your contact list).

You could either simply turn the Email column into a Contact Type column, which would then recognize the email as a Contact.

However if you're looking to associate names and emails together, you can bulk-import contacts to your "My Smartsheet Contacts". If you export the document with the names and emails to a CSV file, then you can import it back in, following the steps here: https://help.smartsheet.com/articles/796143-managing-contacts

Cheers!

Genevieve

Hi @Melisa Dannhauser

If the contacts are in your My Contact list, then they will already be available as an option to select from a Contact column in any sheet you create (as long as the column is not restricted to specific values).

If you start to type a contact's name or email into a Contact Column, the email address & contact from your My Contact list will pop up as you type without it needing to be in the column properties. (Column properties will allow you to create a drop-down list with specific names visible immediately, or to restrict the column to certain contacts.)

Alternatively, you can click on the little person icon, which will bring up a pop-up window showing all the contacts to choose from. This icon:

Our Help Center has more information on the Contact Type of column, see here.

Let me know if this helped answer your question! If not, it would be useful to know why you need to add 1,000 contacts to the column properties to see if there are alternate solutions.

Cheers,

Genevieve