Skip to main content
I can't understand why I keep getting the ISBLANK error here. 

 

AND(OR(ISPICKVAL(Status,'Closed as Duplicate'),

 

ISPICKVAL(Status,'Closed - Resolved'),

 

ISPICKVAL(Status,'Closed - Unresolved'),

 

ISPICKVAL(Status,'Refund Denied'),

 

ISPICKVAL(Status,'Refund Processed')),

 

OR(ISBLANK(ContactId),

 

ISBLANK(Case_Resolution_Comments__c),

 

ISBLANK(Delivery_Type__c),

 

ISBLANK(TEXT(Category__c),

 

ISBLANK(TEXT(Program__c)),

 

ISBLANK(TEXT(Product__c),

 

ISBLANK(TEXT(Reason))))))
2 answers
  1. Mar 20, 2020, 7:05 PM

    Try this = 

    AND(

    OR(

    ISPICKVAL(Status,'Closed as Duplicate'),

    ISPICKVAL(Status,'Closed - Resolved'),

    ISPICKVAL(Status,'Closed - Unresolved'),

    ISPICKVAL(Status,'Refund Denied'),

    ISPICKVAL(Status,'Refund Processed')

    ),

    OR(

    ISBLANK(ContactId),

    ISBLANK(Case_Resolution_Comments__c),

    ISBLANK(Delivery_Type__c),

    ISBLANK(TEXT(Category__c)),

    ISBLANK(TEXT(Program__c)),

    ISBLANK(TEXT(Product__c)),

    ISBLANK(TEXT(Reason))

    )

    )

0/9000