Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vsandlevsandle 

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 )
))
 
Any help/guidance would be much appreciated
 
V-
 
 
Chris ShadeChris Shade
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