Skip to main content
Question

Comparing fields and posting a result

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


    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement