You need to sign in to do that
Don't have an account?
![sfdc_beginner7 sfdc_beginner7](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
AND and OR in validation rule ?
i have to create a validation rule if RecordType is "ITOVC_Alert" and Resolution_Status__c="Closed with actions" and ((EVC__c=FALSE and
ISBLANK( EVC_Comments__c)) or (RCCA__c= FALSE and ISBLANK( RCCA_Description__c ) ) or ISBLANK(Resolution_Closing_Comments__c)) then throw the error , but the rule is not working as expected. If I populating EVC_Comments__c only it is getting saved.
)
AND(
RecordType.DeveloperName ="ITOVC_Alert",
ISPICKVAL( Resolution_Status__c, "Closed with actions") ,
OR(
AND(
EVC__c=FALSE,
ISBLANK( EVC_Comments__c )
),
AND(
RCCA__c= FALSE,
ISBLANK( RCCA_Description__c )
),
ISBLANK(Resolution_Closing_Comments__c)
)
)
What's wrong with my rule?
ISBLANK( EVC_Comments__c)) or (RCCA__c= FALSE and ISBLANK( RCCA_Description__c ) ) or ISBLANK(Resolution_Closing_Comments__c)) then throw the error , but the rule is not working as expected. If I populating EVC_Comments__c only it is getting saved.
)
AND(
RecordType.DeveloperName ="ITOVC_Alert",
ISPICKVAL( Resolution_Status__c, "Closed with actions") ,
OR(
AND(
EVC__c=FALSE,
ISBLANK( EVC_Comments__c )
),
AND(
RCCA__c= FALSE,
ISBLANK( RCCA_Description__c )
),
ISBLANK(Resolution_Closing_Comments__c)
)
)
What's wrong with my rule?