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 ...
Forum Discussion
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.
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.
thanks will try that
