Skip to main content
Topics#Data ManagementPregunta de Jennifer Marsh
Jennifer Marsh (Creation Technologies) ha preguntado en #Data Management
28 abr 2020, 21:46

Validation Rules

When Opportunities are in  stages 2-5 and then closed I want a separate field to be mandatory when the opp closes.  I do not want these fields mandatory for Stage 1.  Is there a way to right a validation rule for this?

 

 
6 respuestas
  1. Tony Trinh
    28 abr 2020, 22:54

    Hi Jennifer,

    AND( 
    CASE(StageName, 
    "Closed Lost", 1,
    "Closed Cancelled",1, 
    "Closed No Award",1, 
    0) = 1, 
    CASE(PRIORVALUE( StageName ), 
    "2.Qualifying", 1, 
    "3.Proposal Development", 1, 
    "4.Validating", 1, 
    "5.Securing", 1, 
    0) = 1, 
    ISBLANK(Business_Awarded_To__c )
    )

     

    Do you have any conflicting validation rules? Please check those.
Escribir una respuesta...
0/9000