Comparing fields and posting a result

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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


Photo of Anthony Butcher

Anthony Butcher

  • 110 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
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.
Photo of Anthony Butcher

Anthony Butcher

  • 110 Points 100 badge 2x thumb
thanks will try that