1

I have an Account validation rule that fires when a specific picklist (Cooling Appliance) value is NOT selected on an Account that has a specific picklist (Program Name2) value selected on another picklist field. Here is the formula:

ISPICKVAL(Program_Name2__c, "Smart House Call - CAC") && 
NOT (ISPICKVAL(Cooling_Appliance__c, "Central AC"))

I need to add additional logic so that the validation rule only fires when the Cooling Appliance picklist is not Null. Basically IF a user selects a value and it is NOT Central AC, the validation rule fires. I tried adding the following to the beginning of the formula but I keep getting syntax errors stating ")" are missing but everytime I add one somewhere it doesnt help. 

IF (NOT(ISBLANK(TEXT(Program_Name2__c)))) &&

I'm not sure if/where in the formula I should have the close parenthesis or if I actually need to add/change functions or operators. Any help would be greatly appreciated.

Improve this question

1 Answer 1

Reset to default
3

The IF at the start of your second function is unnecessary.

NOT(ISBLANK(TEXT(Program_Name2__c))) && ISPICKVAL(Program_Name2__c, "Smart House Call - CAC") && NOT(ISPICKVAL(Cooling_Appliance__c, "Central AC"))

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .