Skip to main content
Topics#FormulasPregunta de Lisa Schutter
Lisa Schutter ha preguntado en #Formulas
21 mar 2017, 8:43

Validation with checkbox and 2 possible fields

Hi Guys, I have already this validation rule in place: 

Debit_Authorization__c &&  ISBLANK(IBAN__c)

now we added an extra field which can be filled instead of the IBAN__c field. So if Debit_Authorization__c, IBAN__c or extra field have to be filled. How can I solve this in one validation? 
5 respuestas
  1. Hemantkumar Jain (CG)
    21 mar 2017, 10:13

    So you want to throw error only when both fields are blank? Use this then:

    AND(Debit_Authorization__c, ISBLANK(IBAN__c),ISBLANK(EXTRA_FIELD_NAME));

     
Escribir una respuesta...
0/9000