You need to sign in to do that
Don't have an account?

Validation Forumula with dual condition
I'm struggling with implementing a validation rule based on a record type. The issue is the status of Closed/Resolved is used across all record types and the validation should only be applied if it is a specific record type.
The validation is:
It is an error if the case record type is Development and the status is Closed/Resolved, require the Validated Date be required.
This is the validation rule I currently have which is being applied on irregardless of record type:
AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")),
ISNULL ( QAValidatedDate__c )
))AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")),
ISNULL ( QAValidatedDate__c )
))
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")),
ISNULL ( QAValidatedDate__c )
))AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")),
ISNULL ( QAValidatedDate__c )
))
Any help/guidance would be much appreciated
V-
I reformated your fmormula for easer consumption:
AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")
),
ISNULL ( QAValidatedDate__c )
)
)
AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")
),
ISNULL ( QAValidatedDate__c )
)
)
If I'm reading this right it is repeating and contains some formatting errors. I looke like the following block of text was repeated or perhaps pasted twice:
AND (
RecordTypeId ="01200000000014WAAQ",
AND(
OR(
ISPICKVAL ( Status , "Closed/Resolved")
),
ISNULL ( QAValidatedDate__c )
)
)
Anyways, I'd try this:
IF(
AND (
RecordTypeId ="01200000000014WAAQ",
ISPICKVAL ( Status , "Closed/Resolved"),
ISNULL ( QAValidatedDate__c )
),
TRUE,
FALSE
)
It is saying if all three of those critera are met at once then the thrown an error (if a valudation result evaluates to TRUE it means the error will be created). Otherwise, everything will be allowed.
Let me know if you like any clarification or if I misunderstood.
If you found this reply helpful please "Like" it and/or mark it as the solution.
Chris