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
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))
)
)