Skip to main content
Topics#FormulasLisa Schutter 的问题
Lisa Schutter 提问于 #Formulas
2017年3月21日 08: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 个回答
  1. Hemantkumar Jain (CG)
    2017年3月21日 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));

     
撰写回答...
0/9000