Skip to main content
Topics#FormulasChristophe LUCCHINI's Question
Christophe LUCCHINI (PELLENC SELECTIVE TECHNOLOGIES) asked in #Formulas
Feb 8, 2018, 3:25 PM

validation rule field

Hi Everyone !

I want to make a validation rule on the object "Opportunity", the rule is basically :

We want to check the Stage of the opportunity , if the opp is in stage = Negotiation / Verbal / Contract / Launched / Invoiced / Closed , and the field "agent" (Sales_Agent__c) is different from "None (Sales Agent)" and the field "Agent_Commission__c" is blank and the field "Agent_Commission_Amount_Manual__c" is blank.

So if all this is gathered, an error message is displayed:"Please check the agent commissions. ..."

So in order to do that , i have created a validation rule , like this:

AND(

OR(

text(StageName) = "Negotiation",

text(StageName) = "Verbal",

text(StageName) = "Contract",

text(StageName) = "Launched",

text(StageName) = "Invoiced",

text(StageName) = "Closed",

OR(

ISBLANK( Agent_Commission__c )

,

Sales_Agent__c<>"None (Sales Agent)"

,

ISBLANK(Agent_Commission_Amount_Manual__c)))

But i have an issue , when we apply the validation rule , even if the field "Agent" is equal to "None (Sales Agent)" the rule still applies.

Thanks for your help !
16 answers
  1. Harshil Parikh
    Feb 13, 2018, 11:52 PM
    I think I see where the problem is.. :)

    Here we go, try this:

     

    AND(
    OR(
    text(StageName) = "Negotiation",
    text(StageName) = "Verbal",
    text(StageName) = "Contract",
    text(StageName) = "Launched",
    text(StageName) = "Invoiced",
    text(StageName) = "Closed"
    ),
    ISBLANK( Agent_Commission__c ),
    Sale_agent_TEXT__c != "None (Sales Agent)",
    ISBLANK(Agent_Commission_Amount_Manual__c)
    )

    Hope this helps and if it solves the issue then mark it as Best Answer!
Loading
Write an answer...
0/9000