Must have been a long week, because I am struggling with this and it seems like it should be easy.
I have a column of first names and a column of last names that I am trying to concatenate into email addresses.
Here’s what I have so far…I’m sure I’m missing one easy component…
The brackets are not placed correctly i think. Also i didn’t understand why you are using the AND function. Are you trying to combine the 3 strings together. Then concatenate is enough i guess.
CONCATENATE (LOWER (MID([First],1,1)), LOWER([Last]), “@fightthebite.net”)
Also you have made the Column Type for this column as Enum which is confusing. If you are trying to save email in this column then better make it as type Email.
AND() is entirely unneeded here.
Right, my mistake.
