formula to create email address
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.
Answers
-
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)
-
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!
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for the feedback and correction!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!