It should stop a user from saving the case as a late order if the status is awaiting shipping and the resolution type is revised new delivery date if the new delivery date is blank.
AND(
ISPICKVAL(Status , "Awaiting Shipping"),
ISPICKVAL(Resolution_Type__c, "Revised New Delivery Date"),
OR(
ISBLANK(New_Delivery_Date__c)
)
)
Any help would be great thank you.
6 respuestas
Hi Jonathan, Please try the below
AND(
ISPICKVAL(Status , "Awaiting Shipping"),
OR(
ISPICKVAL(Resolution_Type__c, "Revised New Delivery Date"),
ISPICKVAL(Resolution_Type__c, "Able to meet orginal Shipment"),
ISBLANK(New_Delivery_Date__c)
)
)
or alternatively
AND(
ISPICKVAL(Status , "Awaiting Shipping"),
OR(
CASE(Resolution_Type__c,
"Revised New Delivery Date",1,
"Able to meet orginal Shipment",1,
0)=1,
ISBLANK(New_Delivery_Date__c)
)
)
