formula to create email address


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!