You need to sign in to do that
Don't have an account?

For CheckBox validation
Hi,
It is urgent .Please Help.
My requirement is:
I have 4 checkboxes are there in Lead and also Percent field. When any of the checkboxes are getting selected the value in the percent field will go on increasing. How to write the validation rule for this one? Please help as soon as possible.
What you are asking for doesnt look like a validation.
If the value in the percent field should be increased when a checkbox is selected, then this should be done with a workflow field update.
If you want to check if the value in the percent field has been increased when a checkbox is selected, then use the formula below
This validation will fire, if any of the checkboxes have been set to true from false and if the value in the percent field has not been increased
You could probably also do this with a formula field:
(if(checkBox1__c, 1, 0)+if(checkBox2__c, 1, 0)+if(checkBox3__c, 1, 0)+if(checkBox4__c, 1, 0))*25
Do you want to validate or wants a formula for percentage increament?
Jake Gmerek's formula will do the the work. But the percentage will only be displayed after the record has been saved. And remember formula fields are not editable.