Hello,
I need assistance with a validation please.
The validation rule must fire, only when (1) criteria are met on a newly created records, or when any one of (2) two fields are changed, but not when the (2) two fields are both zero. It works fine on edited records, but not for new records. On new records the validation rule fires irrespective of whether the criteria are met

(1) AND(AND(RecordType.Name <> 'abc', 
RecordType.Name <> 'def', 
RecordType.Name <> 'gh', 
RecordType.Name <> 'ijk', 
RecordType.Name <> 'lmn') , 
Insured_Value_Accepted__c = False,
(OR(Insured_Value__c >= (RetailValue__c + ( RetailValue__c *10/100)), 
Insured_Value__c <= (RetailValue__c - ( RetailValue__c *10/100))
)))

(2) Insured_Value__c & RetailValue__c

My validation rule:
IF(AND( Insured_Value__c = 0, RetailValue__c = 0),
 False,
 IF( OR(ISCHANGED(Insured_Value__c),ISCHANGED(RetailValue__c),  ISNEW()) ,
  IF(AND(AND(RecordType.Name <> 'abc', 
RecordType.Name <> 'def', 
RecordType.Name <> 'gh', 
RecordType.Name <> 'ijk', 
RecordType.Name <> 'lmn') , 
Insured_Value_Accepted__c = False,
(OR(Insured_Value__c >= (RetailValue__c + ( RetailValue__c *10/100)), 
Insured_Value__c <= (RetailValue__c - ( RetailValue__c *10/100))
))), True, False) ,
 false) )

Any assistance would be greatly appreciated!

Hi, 

 I am adding number of years or months or days based on the pick list value selected below is the case formula used it is working proper for years values for months and days it is displaying error please suggest what might be the mistake in the below formula. 

CASE(1,
     IF(ISPICKVAL (cldy_uom__c, "Year(s)"),1,0), 
     (  DATE(YEAR(cldy_subscription_start_date__c) + VALUE(Subscription_Term_Formula__c),
             MONTH(cldy_subscription_start_date__c),
             DAY(cldy_subscription_start_date__c))
      ),
      IF(ISPICKVAL (cldy_uom__c, "Month(s)"),1,0), 
     (  
       DATE(YEAR(cldy_subscription_start_date__c),
            MONTH(cldy_subscription_start_date__c) + VALUE(Subscription_Term_Formula__c),
            DAY(cldy_subscription_start_date__c))
      ),
      IF(ISPICKVAL (cldy_uom__c, "Day(s)"),1,0), 
     (  
       DATE(YEAR(cldy_subscription_start_date__c),
            MONTH(cldy_subscription_start_date__c),
            DAY(cldy_subscription_start_date__c) + VALUE(Subscription_Term_Formula__c))
      ),
        ( DATE(YEAR(cldy_subscription_start_date__c),
            MONTH(cldy_subscription_start_date__c),
            DAY(cldy_subscription_start_date__c) ) )
)

Thanks
Sudhir

Does anyone know how to create a validation rule to block viewing of cases if the case owner is a queue?

I would like to prevent cherry picking of cases before cases are assigned to agents.

Thank you in advance!

Hello,
I need assistance with a validation please.
The validation rule must fire, only when (1) criteria are met on a newly created records, or when any one of (2) two fields are changed, but not when the (2) two fields are both zero. It works fine on edited records, but not for new records. On new records the validation rule fires irrespective of whether the criteria are met

(1) AND(AND(RecordType.Name <> 'abc', 
RecordType.Name <> 'def', 
RecordType.Name <> 'gh', 
RecordType.Name <> 'ijk', 
RecordType.Name <> 'lmn') , 
Insured_Value_Accepted__c = False,
(OR(Insured_Value__c >= (RetailValue__c + ( RetailValue__c *10/100)), 
Insured_Value__c <= (RetailValue__c - ( RetailValue__c *10/100))
)))

(2) Insured_Value__c & RetailValue__c

My validation rule:
IF(AND( Insured_Value__c = 0, RetailValue__c = 0),
 False,
 IF( OR(ISCHANGED(Insured_Value__c),ISCHANGED(RetailValue__c),  ISNEW()) ,
  IF(AND(AND(RecordType.Name <> 'abc', 
RecordType.Name <> 'def', 
RecordType.Name <> 'gh', 
RecordType.Name <> 'ijk', 
RecordType.Name <> 'lmn') , 
Insured_Value_Accepted__c = False,
(OR(Insured_Value__c >= (RetailValue__c + ( RetailValue__c *10/100)), 
Insured_Value__c <= (RetailValue__c - ( RetailValue__c *10/100))
))), True, False) ,
 false) )

Any assistance would be greatly appreciated!