Skip to main content
Topics#Data ManagementMudasar Kayani's Question
Mudasar Kayani asked in #Data Management
May 23, 2016, 11:31 AM

validation rule on opportunity stage

Hi,

 

I have a validation below:

 

IF(

 

AND(

 

TEXT(Reason_for_Dead_Opportunity__c ) = "Superseded with another Opportunity",

 

ISBLANK( Replacement_Opportunity_Number__c )), True, False)

 

Basically if the Opportunity is dead and the reason is 'Superseded with another Opportunity' then you must populate the Replacement Opportunity number. This works however I have another validation which also kicks in and i dont want it to, the other validation is below:

 

ISPICKVAL (PRIORVALUE (StageName), "Dead")

 

So if the stage name is dead you cannot move back. Does this make sense.
13 answers
  1. Akhil Anil (Intigris)
    May 23, 2016, 1:45 PM
    Try this

     

    Validation rule 1

     

     

    IF((TEXT(Reason_for_Dead_Opportunity__c ) <> "Superseded with another Opportunity"),ISPICKVAL(PRIORVALUE (StageName), "Dead"),FALSE)

     

    Validation rule 2

     

     

    AND(TEXT(Reason_for_Dead_Opportunity__c ) = "Superseded with another Opportunity",ISBLANK( Replacement_Opportunity_Number__c ))

     

    Regards,

     

    Akhil
Write an answer...
0/9000