[SalesForce] Validation Rules: If the status is change

EDIT:

I have break down the validation and I found where it is failing:
the below validation works fine and it fires when I try to save the blank:

AND(ISPICKVAL(Status__c, "Completed"),
 (ISBLANK(Completion_Date__c ) 
))

This validation rules does not fire:

AND (
ISPICKVAL(Status__c, "Completed"),
(ISBLANK (Completion_Date__c )),
(ISBLANK (Last_Completion_Date__c))
)

So the question is: How can I had more fields if the status changed to Completed?

I have the validation rule that is ACTIVE and does not fire when I test it:

here is what I have:

AND (
ISPICKVAL(Status__c, "Completed"),
(ISBLANK (Completion_Date__c )),
(ISBLANK (Last_Completion_Date__c))
)

the Completion_Date__c & Last_Completion_Date__c is required field only when the Status__c is changed to Completed

Best Answer

Here is I able to solve the above validation. I hope it will help somebody who is looking.

AND(ISPICKVAL(Status__c, "Completed")
,
OR(
 ISBLANK(Completion_Date__c),
 ISBLANK(Last_Completion_Date__c) //you can multiple fields just by adding here....   
))
Related Topic