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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Kaisa Janzen

Kaisa Janzen

  • 300 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
what type of field is field b?
also, what type of field is field a?
if([Field A]="xxx@xxx.com",[Field B],[Field A])
Photo of Kaisa Janzen

Kaisa Janzen

  • 300 Points 250 badge 2x thumb
It was an email field.  This formula works perfectly!  Thank you!