function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sankar GaneshSankar Ganesh 

Validation error on Ischanged and Isblank

My requirement is whenever the active checkbox(default checked) is unchecked then user must enter resign otherwise error should show to user.Below is my code for this requirement but it doesn`t work and I didn't get any error in validation.
       AND(ISCHANGED( Active__c ), ISBLANK( Resign_Date__c ) )
Dilip_VDilip_V
Hi Sankar,

Try like this 
AND(Active__C=false, NOT(ISBLANK( Resign_Date__c )) )
Or
AND(ISCHANGED( Active__c ), NOT(ISBLANK( Resign_Date__c )) )



Thanks.
Sankar GaneshSankar Ganesh
No, I didn't get the result I wanted.why you give Active=false and Resign_Date as not blank? If Resign _date is filled(Not Blank) then Ative=false which is true,we don't neeed to show any error message to user. Any way after some struggle I got the correct one I created two validation like this
1.AND( Active__c =true, ! ISBLANK( Resign_Date__c ) )
2.AND(Active__c=false, ISBLANK( Resign_Date__c ))
I think I can combine this with OR as one validation rule.