If these two picklist values are found to be true
ISPICKVAL(Type, Product Fault)
ISPICKVAL(Status, CLOSED)
Then one of these values needs to be selected
ISPICKVAL(Scrap_Keep_Return__c, Scrap , Keep ,Return)
and this date field cannot be blank
Date_for_item_Disposal__c
Thanks in advance for your help and guidance...
3 answers
Hi James, Please try the below
AND(
ISPICKVAL(Type,'Product Fault'),
ISPICKVAL(Status,'CLOSED'),
OR(
ISBLANK(Date_for_item_Disposal__c),
CASE(Scrap_Keep_Return__c,
'Scrap',1,
'Keep',1,
'Return',1,
0)=0
)
)
