I have an object that has a series of checkboxes where the person completing the record indicates if any of the areas need repairs. They go something like:
Checkbox- Walls in need of repair?
Checkbox- Doors in need of repair?
Etc.
I would like to create a formula that evaluates if ANY of these checkboxes are true and then returns a value that indicates that something is in need of repair. I've tried doing OR(IF formulas and I've tried doing CASE formulas but cannot seem to create one that does not give me an error message. I don't really care how the formula returns the result-I had originally tried to design it to just be a checkbox on the object that is checked if something is in need of repair but I don't care what type of value it returns as long as the formula works.
I am making this field so that I can make a validation rule. We want users to create a maintenance request whenever there is a repair needed and there is a lookup field on the object that links to maintenance requests. I want a validation rule that requires there to be a value in the lookup field if any repairs are needed. But I am having trouble with the formula.
Help? Suggestions?
5 risposte
Okay to check that at least one of the 12 checkboxes has been selected you could use a VR kinda like this:
(IF(Repair_Paint__c, 1, 0) +
IF(Repair_Electric__c, 1, 0) +
IF(Repair_Plumbing__c, 1, 0) +
IF(Repair_HVAC__c, 1, 0)) < 1
