Forum Discussion
Solved
calculated Email column
i'm trying to set a calculated Email column When i set this formula to concatenate from First Nam & Name it works perfectly =[First Name]&""&NAME&"@"&"somedomain.some" The problem is one user have...
The syntax is like this 🙂
=IF([First Name]="Ash","HerEmail",[First Name]&""&NAME&"@"&"somedomain.some")
If it's her name then set her email, else set the whats inputed 🙂
Syntax is the same as in Excel:
=IF( condition1 , IF( condition2, TRUE , FALSE) , IF( condition3, TRUE , FALSE) )
Final question...
Suppose i wand to remove a special french character from her name example: "É" and replace it with no accent "E" in HerEnail address ?
Suppose i wand to remove a special french character from her name example: "É" and replace it with no accent "E" in HerEnail address ?
=REPLACE([YourColumnname],FIND("É",[YourColumnname]),1," E ") Should do it 🙂