0

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

9
  • Did you try using ISNULL() ? over ISBLANK()
    – Sanjay
    Jun 15, 2015 at 16:04
  • tried isnull did not work either
    – Nick
    Jun 15, 2015 at 16:06
  • 1
    Try this - AND(ISCHANGED(Status__c), ISPICKVAL(Status__c, "Completed"), (ISBLANK (Completion_Date__c )), (ISBLANK (Last_Completion_Date__c)) )
    – Sanjay
    Jun 15, 2015 at 16:07
  • @Sanjay: Did not fire the validation
    – Nick
    Jun 15, 2015 at 16:12
  • At this point you need to break down your logic and check for the conditions with just Completion Date and Last Completion Date irrespective of the Status. If it works then probably the IsPickVal() maybe causing issue. Try using Contains() as well IsPickVal(contains(Status__c,"Completed")
    – Sanjay
    Jun 15, 2015 at 16:25

1 Answer 1

3

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....   
))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .