Skip to main content
Topics#FormulasQuestion de Bella Cotrone
Bella Cotrone (COREFX) a posé une question dans #Formulas
20 janv. 2022, 16:28

Validation Question

Hello, I am trying to write a validation rule for 11 fields based on a picklist field, but don't want to create 11 validation rules. I have tried the below formula but received this Error: Incorrect number of parameters for function 'ISBLANK()'. Expected 1, received 2

I think I am missing a (parent but can't figure out where. Any help is greatly appreciated!

AND( TEXT( Opportunity_Type__c ) = "Project", ISBLANK(TEXT( Allergen_Restrictions__c ), ISBLANK(TEXT(  Sample_for_comparison_if_available__c ), ISBLANK(TEXT(  Product_Specification_if_a_match__c ), ISBLANK(TEXT(  Non_GMO__c ), ISBLANK(TEXT(  Kosher__c ), ISBLANK(TEXT(  Organic__c ), ISBLANK(TEXT(  Halal_or_Halal_compliant__c ), ISBLANK(TEXT(  Country_of_Origin_Restrictions__c ), ISBLANK(TEXT(  EU_compliant__c ), ISBLANK(TEXT(  Micro_or_Analytical_Testing_requirement__c ), ISBLANK(TEXT(  Heavy_metal_limits_CA_prop_65__c )))))))))))))

2 réponses
  1. Jake Brushafer (Penrod)
    20 janv. 2022, 18:34
    Give this a try looks like your ")"s were out place
    AND( TEXT( Opportunity_Type__c ) = "Project",
     ISBLANK(TEXT( Allergen_Restrictions__c )),
      ISBLANK(TEXT(  Sample_for_comparison_if_available__c )), 
      ISBLANK(TEXT(  Product_Specification_if_a_match__c )), 
      ISBLANK(TEXT(  Non_GMO__c )),
       ISBLANK(TEXT(  Kosher__c )),
        ISBLANK(TEXT(  Organic__c )), 
        ISBLANK(TEXT(  Halal_or_Halal_compliant__c )), 
        ISBLANK(TEXT(  Country_of_Origin_Restrictions__c )),
         ISBLANK(TEXT(  EU_compliant__c )),
          ISBLANK(TEXT(  Micro_or_Analytical_Testing_requirement__c )), 
          ISBLANK(TEXT(  Heavy_metal_limits_CA_prop_65__c )))
Rédiger une réponse...
0/9000