Skip to main content
Topics#Data ManagementMegan Hooser の質問
Megan Hooser (Salesforce) が「#Data Management」で質問
2016年10月21日 13:59

Validation Rule Help

Trying to write a validation rule to verify that if the opportunity stage is closed won, the various picklists are filled out for our safety measures. I'm getting the error:syntax error :Missing ) 

 

But that doesn't seem right to me. What did I do wrong here?

 

IF( 

 

AND( TEXT(StageName) = "Closed Won", 

 

ISBLANK(TEXT(Sub_contractor__c)),

 

ISBLANK(TEXT( Bonding_Required__c)), 

 

ISBLANK(TEXT( AA_EOE_Set_Aside_Required_SBE__c)), 

 

ISBLANK(TEXT( AIA_Documentation_Required__c)), 

 

ISBLANK(TEXT( Certified_Payroll_Required__c)), 

 

ISBLANK(TEXT( (Prevailing_Wage__c)), 

 

ISBLANK(TEXT( Wage_Sheet_Included__c)), 

 

ISBLANK(TEXT( Incremental_Billing_Required__c)), 

 

ISBLANK(TEXT( Open_Book__c)), 

 

ISBLANK(TEXT( Security_Badges_Required__c)),  

 

ISBLANK(TEXT( Extra_Safety_Training_Required__c))))
4 件の回答
  1. Sunil Sarilla (M&G Investments)
    2016年10月21日 14:11
    Hi Megan,

     

    Assuming the requirement is for users to complete the various picklists provided Stage is closed Won, the formula will be as below

    AND( 
    TEXT(StageName) = "Closed Won", 
    OR(
    ISBLANK(TEXT(Sub_contractor__c)),
    ISBLANK(TEXT( Bonding_Required__c)), 
    ISBLANK(TEXT( AA_EOE_Set_Aside_Required_SBE__c)), 
    ISBLANK(TEXT( AIA_Documentation_Required__c)), 
    ISBLANK(TEXT( Certified_Payroll_Required__c)), 
    ISBLANK(TEXT( Prevailing_Wage__c)), 
    ISBLANK(TEXT( Wage_Sheet_Included__c)), 
    ISBLANK(TEXT( Incremental_Billing_Required__c)), 
    ISBLANK(TEXT( Open_Book__c)), 
    ISBLANK(TEXT( Security_Badges_Required__c)),  
    ISBLANK(TEXT( Extra_Safety_Training_Required__c))
     )
    )

     

     
回答を記入...
0/9000