Issue with Concatenate formula

HAA

I'm currently using the below formula, however it's abbreviating the first name rather than spelling out the whole name. I'm having a hard time identifying what I'm missing within the formula:

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

Cory Page

@HAA Oops I had a random ) after the 1 and we no longer needed the ,1 I just removed them we should be fine now.

=[First Name]@row + "." + [Last Name]@row + "@gmail.com"

Cory Page

Hello, you're formula is taking the first name and going left by 1 then adding a .

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

This should fix it

=[First Name]@row, 1) + "." + [Last Name]@row + "@gmail.com"

HAA

@Cory Page I updated the formula on my sheet and it's still showing an error. I tried to add parenthesis to either end. Could this be an issue with my actual sheet?

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

Cory Page

@HAA Oops I had a random ) after the 1 and we no longer needed the ,1 I just removed them we should be fine now.

=[First Name]@row + "." + [Last Name]@row + "@gmail.com"

HAA

@Cory Page That was helpful! I'm still in my elementary phase of SS formulas so I still need a bit of guidance, which you provided! So thank you!