Discussions

Expand all | Collapse all

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

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

    Posted 05-18-2017 20:36
    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.


  • 2.  RE: If formula that can display value from one of two fields depending on the contents of the fields

    Bronze
    Contributor
    Posted 05-18-2017 20:58
    what type of field is field b?


  • 3.  RE: If formula that can display value from one of two fields depending on the contents of the fields

    Bronze
    Contributor
    Posted 05-18-2017 21:00
    also, what type of field is field a?


  • 4.  RE: If formula that can display value from one of two fields depending on the contents of the fields

    Bronze
    Contributor
    Posted 05-18-2017 20:59
    if([Field A]="xxx@xxx.com",[Field B],[Field A])


  • 5.  RE: If formula that can display value from one of two fields depending on the contents of the fields

    Posted 05-18-2017 21:02
    It was an email field.  This formula works perfectly!  Thank you!