Formula to combine Name and email to create a contact row

Formula to combine Name and email to create a contact row

Hello,

I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person.


I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact.

Help please!

Answers

  • 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

  • @Genevieve P I have the same issue as the OP. I wanted to follow up on your answer and see if you can clarify.


    I know that I can import contacts from a csv file into SS. This will create the contacts in my SS account. But how do I then add those contacts to a sheet - in BULK. I currently have 1,000 contacts that I need added to a contact list within a specific sheet. I know I can import them to the SS account but is there a way to then create a contact list for a specific sheet with all those contacts? I mean besides having to type them in one by one in the column properties, since that would take forever.

    Thanks!!!

  • 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

Sign In or Register to comment.