Since I have gotten great assistance previously, thought I'd request more assistance with yet another validation rule. I get no syntax errors and the validation rules fires but only when all fields referenced are null. Here is what the business wants: If there is nothing in the DB Manufacturer field, and the sub type is EBR/EFR Needs Office Review then • EITHER Boiler Type OR Furnace Type needs to be input • Both of the following fields need to be supplied: MFG Year Fuel Type
This is what I have created:
DB_Manufacturer__c = "" && ISPICKVAL(Sub_Type__c, 'EBR/EFR Needs Office Review') && ISPICKVAL(Boiler_Type__c, '') && ISPICKVAL(Furnace_Type__c, '') && (ISBLANK(MFG_Year__c) || ISPICKVAL(Fuel_Type__c, '') || ISBLANK( Manufacturer__c ))
Once I select a Boiler Type and no other fields, the validation rules no longer fires. There has to be something with my grouping or AND's and Or's. Any assistance is appreciated.