Forum Discussion

Copper Contributor

Oct 23, 2022

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...

SharePoint Online

NicolasKheirallah
Oct 23, 2022
AndyPeper
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) )

NicolasKheirallah

MVP

Oct 23, 2022

AndyPeper

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) )

AndyPeper
Copper Contributor
Oct 23, 2022
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 ?
- NicolasKheirallah
  MVP
  Oct 23, 2022
  =REPLACE([YourColumnname],FIND("É",[YourColumnname]),1," E ") Should do it 🙂
AndyPeper
Copper Contributor
Oct 23, 2022
I tried this and seems to work for multiple exeption

=IF([First Name]="Ash","HerEmail",IF([First Name]="Carol Ann","HerEmail",[First Name]&""&NAME&"@"&"somedomain.come"))
- NicolasKheirallah
  MVP
  Oct 23, 2022
  Yes exactly! It becomes basicly nested in each other. 🙂 You can also do as I wrote in the example above!
AndyPeper
Copper Contributor
Oct 23, 2022
Another question
Can i have multile IF statment
Suppose that i have 1 more or other users that need special synthax ?
AndyPeper
Copper Contributor
Oct 23, 2022
Perfect ! Works like a charm

thx NicolasKheirallah