Skip to main content
Topics#Data ManagementDomanda di Jennifer Marsh
Jennifer Marsh (Creation Technologies) ha fatto una domanda in #Data Management
10 mag 2020, 19:16

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.    For this I have been using this rule:

 

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 )

 

)

 

The problem is that the rule is not required the Business Awarded to filed to be filled in.  

 

Just curious what I have done wrong.  
6 risposte
Scrivi una risposta...
0/9000