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
cunninjacunninja 

Task Validation Rule Help

Hey Everyone,

 

I'm pretty new with validation rules and was hoping to get some help with writing one on a task. Here are the requirements-

 

I don't want a user to be able to mark a task completed unless four checkboxes are marked true on the task first.

 

So i guess it would be something if w,x,y,z checkboxes are "false" status can't equal "completed" or something like that.

 

Thanks for your help!

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

here you go (you owe me a beer!) 

 

AND(ISPICKVAL(Picklist_1__c, "A"),
OR(
NOT( Checkbox_1__c ),
NOT( Checkbox_2__c ), 
NOT( Checkbox_3__c ),  
NOT( Checkbox_4__c )))

 

 

All Answers

Steve :-/Steve :-/

here you go (you owe me a beer!) 

 

AND(ISPICKVAL(Picklist_1__c, "A"),
OR(
NOT( Checkbox_1__c ),
NOT( Checkbox_2__c ), 
NOT( Checkbox_3__c ),  
NOT( Checkbox_4__c )))

 

 

This was selected as the best answer
cunninjacunninja

Great! Thanks so much!...i probably owe you a case after i tack on an additional question tho...anyway to have this validation criteria evaluate ONLY when the subject of a task equals a certain something?...say only show the error message if the Subject = X? Thanks again!
Steve :-/Steve :-/

you mean like this?

 

For THAT you owe me some of these -> http://beeradvocate.com/beer/profile/863/7971

 

AND(
ISPICKVAL(Picklist_1__c, "A"),
CONTAINS(Subject, "X"),
OR(
NOT( Checkbox_1__c ),
NOT( Checkbox_2__c ), 
NOT( Checkbox_3__c ),  
NOT( Checkbox_4__c )))