AND(
ISCHANGED( Ministry_Category__c ),
ISBLANK( Reason_For_Ministry_Category_Change__c ) )
The problem is, on some records the Ministry Category is initially blank and sometimes the Category field can change more than once.
If the rule fires for the first time and a Reason is entered and if there is a second update, the rule won’t fire since there is already something in the Reason field.
I’m not sure how to update the validation rule to include a second update?
7 answers
OK that makes it clear. Use this then:
AND(
NOT(ISBLANK(TEXT(PRIORVALUE(Ministry_Category__c )))),
ISCHANGED( Ministry_Category__c ),
OR(
ISBLANK( Reason_For_Ministry_Category_Change__c ),
NOT(ISCHANGED(Reason_For_Ministry_Category_Change__c ))
)
)
