function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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 :-/Steve :-/
AND(
ISBLANK(CommisionRate__c),
NOT(ISBLANK(Producer__c)),
UnkownFieldName <> "Direct Sale - GA")