Oct 23 2022 06:40 AM
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 her email in a different format and cannot use the previous formula
Can i use an IF function ?
I try this but i'm newbie and can't get it to work..is it possible ?
=IF([First Name]="Ash","email address",""","
(IF[First Name]&""&NAME&"@"&"somedomain.some""))
Thanks
Oct 23 2022 08:55 AM - edited Oct 23 2022 08:56 AM
SolutionThe 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) )
Oct 23 2022 11:54 AM
Oct 23 2022 12:05 PM - edited Oct 23 2022 12:05 PM
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"))
Oct 23 2022 12:27 PM
Oct 23 2022 12:30 PM
Oct 23 2022 12:47 PM
Oct 23 2022 08:55 AM - edited Oct 23 2022 08:56 AM
SolutionThe 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) )