Auto create a contact based off 3 columns

Jon Barto
Jon Barto ✭✭✭✭✭

Is it possible to create a contact column based off info from 3 other columns.

Customer First Name (colum1) , Customer last Name (column 2), Email Address (column 3) Created contact is column 4 (a contact column)


  • Cory Page
    Cory Page ✭✭✭✭✭

    I just tested and it seems you can create a contact using a pretty simple formula so long as your @something.something is always the same.

    I used my name in my sheet and it linked right up to my contact in the list, it seems so long as your emails are loaded it should be fine.

    If you have other emails we might need to make some changes but this is a very basic setup, if it works cool if not let us know.

    =[First Name]@row + "." + [Last name]@row + ""

    ^I added a . because thats our email format but it depends what your format would be^

  • Ramzi
    Ramzi ✭✭✭✭✭

    If you're trying to get a format like this: Bob Smith <>, for example, you can use a formula to concatenate everything together in the contact column, but it will not resolve correctly to a contact. Your best bet is to just use the email address in the contact column.

    Smartsheet Solutions Architect