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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks for the feedback and correction!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!