Hi,
I am trying to create a validation rule that if field a (date/time), field b (date/time), and field c (picklist) are blank, field d (picklist) cannot be set to "closed". This is what I have but I know it isn't correct -
OR(
ISBLANK ( Actual_Delivery_Time__c ),
ISBLANK ( LifePort_Returned_Date_Time__c ),
ISPICKVAL ( Final_Organ_Disposition__c, "" ),
ISPICKVAL ( Status__c, "Closed")
)
Can someone please help? Thank you!
4 answers
Give this a try
AND(
ISPICKVAL ( Status__c, "Closed"),
OR(
ISBLANK ( Actual_Delivery_Time__c ),
ISBLANK ( LifePort_Returned_Date_Time__c ),
ISBLANK(TEXT( Final_Organ_Disposition__c ))
)
)
