Discussions

 View Only
  • 1.  Comparing fields and posting a result

    Posted 08-31-2018 13:29
    I'm trying to display a value in field 3 using a formula see example below

    so if field 1 and 2 have a value don't call
    if field 1 or 2 are empty or both fields are empty call.

    Eg

    Field 1                  Field 2                   Field 3 
    23                        01/05/2017             don't call
    515                      blank                       call
    54848                  01/05/2017             don't call
    Blank                   blank                       call
    Blank                   01/05/2017              call




  • 2.  RE: Comparing fields and posting a result

    Posted 08-31-2018 17:41
    Hello, 

    I would write a formula similar to this:

    If([Field1]="blank" OR [Field2]="blank", "Call","Don't Call")
    if the field is truly blank, as in, a null value, replace "blank" with "" in the formula.
    If([Field1]="" OR [Field2]="", "Call","Don't Call")

    Let me know if this helps.


  • 3.  RE: Comparing fields and posting a result

    Posted 09-04-2018 12:30
    thanks will try that