+ Start a Discussion
sumit dsumit d 

validation formula for checkbox

Hi All,
         I want to create a validation rule which have conditions below:-
1. When IsReccur__c(checkbox) is true and ReccurWithTime___c(Checkbox) is false and reccurType__c(Picklist) and NumberReccur__c(Picklist) is null than show error :- You cant save record.
2. When IsReccur__c is false and ReccurWithTime___c is also false,
 and EndTime(Date/Time) and startTime(Date/TIme)  is not blank than show error.
3.  When IsReccur__c is True and ReccurWithTime___c is also True,
 and EndTime(Date/Time) and startTime(Date/TIme)  is not blank than show error.
Can anyone help me with this validation?
Best Answer chosen by sumit d
Abdul KhatriAbdul Khatri
Hi Sumit

Please try this
OR(
AND( IsReccur__c , NOT( ReccurWithTime__c) ,  ISBLANK( TEXT( reccurType__c ) ) ,  ISBLANK( TEXT( NumberReccur__c ) ) ),
AND( NOT( IsReccur__c ) , NOT( ReccurWithTime__c) , NOT( ISBLANK( EndTime__c ) ) , NOT( ISBLANK( startTime__c ) ) ),
AND( IsReccur__c , ReccurWithTime__c , NOT( ISBLANK( EndTime__c ) ) , NOT( ISBLANK( startTime__c ) ) )
)