Location is a Lookup Field and adding that to validation does not work. Only
And (Sent_to__c =True, PRIORVALUE(Item__c) > Item__c) is working great but when I want to add condition (fire validation when Location is not changed) then it does not work. Any suggestion please.
AND(Not(Ischanged(Location__c)),
Sent_to__c =True,
PRIORVALUE(Item__c) > Item__c )
Thank you
3 answers
Hello sunil,
Looks like it should work please compare the rule in org again with the rule u posted please post screenshot of the rule
AND(
Not(Ischanged(Location__c)),
Sent_to__c =True,
PRIORVALUE(Item__c) > Item__c
)