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.