You need to sign in to do that
Don't have an account?
vikas malik
Validation rule help needed
1) i am having a picklist field called as "Type__c" if the value of type is set to "Other Adjustment" then i am having other 2 picklist fields like "Month__c" and "Year__c" should be mandatory
IF(
AND(
NOT(
ISPICKVAL(Type__c, 'Other Adjustment')),ISBLANK( ADR_Move_From_Month__c),ISBLANK( ADR_Move_From_Year__c)), true, false)
IF(
AND(
NOT(
ISPICKVAL(Type__c, 'Other Adjustment')),ISBLANK( ADR_Move_From_Month__c),ISBLANK( ADR_Move_From_Year__c)), true, false)
AND(
NOT(
ISPICKVAL(Type__c, 'Other Adjustment')),ISBLANK( TEXT(ADR_Move_From_Month__c)),ISBLANK(TEXT(ADR_Move_From_Year__c))), true, false)
try this
All Answers
Try this:
AND( ISPICKVAL(Type__c,"Other Adjustment"),
OR (ISPICKVAL(ADR_Move_From_Month__c,''),
ISPICKVAL(ADR_Move_From_Year__c,'') ) )
Thanks,
Pratik
P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.
The above Rule will check: If Type__c is Other Adjustments and any one of picklistlist ADR_Move_From_Month__c or ADR_Move_From_Year__c is blank; it will throw error.
Thanks,
Pratik
use this validation rule:
Thanks
Anil.B
AND(
NOT(
ISPICKVAL(Type__c, 'Other Adjustment')),ISBLANK( TEXT(ADR_Move_From_Month__c)),ISBLANK(TEXT(ADR_Move_From_Year__c))), true, false)
try this