+ Start a Discussion
rayraysrayrays 

Validation when field is not blank and does not equal a certain value.

Hi,

 

How would I create an opportunity validation for the following:

Commission % is required when Producer is not blank and not equal Direct Sale - GA

 

Thanks in advance.

 

-Ray

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis
AND(
ISBLANK(CommisionRate__c),
NOT(ISBLANK(Producer__c)),
UnkownFieldName <> "Direct Sale - GA")