Skip to main content
Question

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

  • May 19, 2017 12:36 AM UTC
  • 0 replies
  • 44 views

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.

  • Registered
  • May 19, 2017 12:58 AM UTC
what type of field is field b?

  • Registered
  • May 19, 2017 12:59 AM UTC
if([Field A]="xxx@xxx.com",[Field B],[Field A])

Forum|alt.badge.img+3
  • Author
  • Registered
  • May 19, 2017 1:02 AM UTC
It was an email field.  This formula works perfectly!  Thank you!