Skip to main content
Question

If formula that can display value from one of two fields depending on the contents of the fields


Forum|alt.badge.img+3
I'm attempting to write a formula that seems like it should be simple, but I cannot get it to work.

In Field C (text formula field), I need a formula that I presume will use an If statement.

If Field A contains "xxx@xxxx.com", display contents of Field B
Otherwise/Else show contents of field A in field C.

(the "xxx@xxx.com" email address trigger will always be the same email address.)

Any help would be appreciated.  Thanks.
This topic has been closed for replies.

what type of field is field b?

if([Field A]="xxx@xxx.com",[Field B],[Field A])

Forum|alt.badge.img+3
It was an email field.  This formula works perfectly!  Thank you!