Hello Folks,
I have a "Type" field in type field i have two picklist values "Merchant Related" and "Service/Status" and for this if status is "closed" and "Resolved" then i want MID field mandatory.
I have written below Validation Rule and its working for Service/status Type but not for merchant related type. Even for merchant its working on Resolved status but not on Closed status.
Can someone help me with this?
Thanks in advance.
AND( ISPICKVAL(Status, "Resolved"), OR( ISPICKVAL(Status, "Closed"), ISPICKVAL(Type, "Service/Status"), ISPICKVAL(Type, "Merchant Related"), ISBLANK( MID__c )))
3 respuestas
Try this
AND(
CASE(Status,
"Resolved",1,
"Closed",1,
0 ) = 1,
CASE( Type,
"Service/Status",1,
"Merchant Related",1,
0) = 1,
ISBLANK( MID__c )
)
