formula to create email address

Suzi

Hi

I'm new to using formulas. How can I create a formula to populate someone's email address into another box? The email address would be the first initial of their first name Last name @ our company name.

Thanks for any direction to where I can learn to do this.

Chadd

Use the CONCAT (concatenation) function... Something like this should work, where the cell references contain the First Name (D3), Last Name(C3), Company Name(E3). and .com(F3).

=CONCAT(LEFT(D3,1),C3,"@",E3,F3)

Nick Korna

Hi @Suzi ,

In the column for generation the email address:

=(LEFT([First Name]@row, 1) + [Last Name]@row + "@companyname.com")

You can set the generated email column to a contacts list if required or leave as text.

Examples (top with column set to contact list, bottom just as text):

One potential problem may be if you have any non-unique first initial & last name combinations in your data. For example, if John Doe also joined the example company above he would have the same generated email as Jane.

You can add a further column and/or conditional formatting to show these if required.

Hope this helps; if you've any questions etc. then just ask!

Genevieve P.

Hi @Chadd

That looks to be an excel formula - Smartsheet formulas work a little differently.

@Suzi: I agree with Nick!

Here are some Help Articles that may be useful:

Combine (Concatenate) Text or Values from Two or More Cells with a Simple Formula

Create a Cell or Column Reference in a Formula

Cheers,

Genevieve

Chadd

Thanks for the feedback and correction!