+ Start a Discussion
Paula VoglerPaula Vogler 

Need assistance with a validation rule

I have a request from one of my business units to require 3 fields have a value when another field has a specific value.
IE: When case.Status_Type__c (picklist)= "BR Verified On-Site" then the following 3 fields ALL need to be populated:
MFG_Year__c (Text)
Boiler_Type__c (Picklist)
Fuel_Type__c (Picklist)


I know I can do this with 3 separate validation rules but was wondering if anyone knew how to create 1 rule that will accomodate all scenarios?

Any help would be greatly appreciated.
Best Answer chosen by Paula Vogler
Eric-∑Eric-∑
Try this out.

ISPICKVAL(Status_Type__c, 'BR Verified On-Site') && (ISBLANK(MFG_Year__c) || ISPICKVAL(Boiler_Type__c, '') || ISPICKVAL(Fuel_Type__c, ''))

All Answers

Eric-∑Eric-∑
Try this out.

ISPICKVAL(Status_Type__c, 'BR Verified On-Site') && (ISBLANK(MFG_Year__c) || ISPICKVAL(Boiler_Type__c, '') || ISPICKVAL(Fuel_Type__c, ''))
This was selected as the best answer
Paula VoglerPaula Vogler
Did the trick! Thanks so much!
Eric-∑Eric-∑
Glad to know it helps. Please choose it as "Best Answer" to mark it solved.