Need help in creating a validation rule,
As per the requirment,(see below) I need a validation rule that does the following:
IF: Production Type = Full Production, and Version = 1, or Production Type = Full Production/Tax Update, or Production Type = Full Production/Prelim, or
AND: Value = [blank]
THEN: Capture picklist options can only be:
Analyzing Files Business Decision Capture Analyst Out
ELSE: Capture Status picklist options can be the existing complete picklist.
The Data type of Production Type,Version and Capture is picklist fields and Value is text field.
According to the requirment i have created a below rule:
AND( OR( ISPICKVAL(Production_Type__c,"Full Production"), ISPICKVAL(Version__c,"1"), ISBLANK(Value__c) ), TEXT(Capture__c)<>"Analyzing Files", TEXT(Capture__c)<>"Business Decision" )
The problem with rule is that , Can't modify Production type,Version and Value fields until and unless i change Capture field to "Analyzing Files" and "Business Decision" Could anyone help me on this rule.
Thanks in Advance!