Ask Search:
Teri CurtinTeri Curtin 

Validation Rule

I have a picklist field: Assessment Site, which based on the response (and only these responses) will require a selection in another field; otherwise, it it not required.  What's happening is that the form cannot be submitted without any response - cannot be left blank.  

AND(
OR(

ISPICKVAL(Assessment_Site__c, "Ridgewood, NJ"),
ISPICKVAL(Assessment_Site__c, "New York, NY"),
ISPICKVAL(Assessment_Site__c, "Mount Laurel, NJ"),
     ISBLANK(TEXT(Must_obtain_labs_prior_to_assessment__c))
))
Best Answer chosen by Teri Curtin
Deepak AnandDeepak Anand
Close. Try this = 
AND(
    OR(
        ISPICKVAL(Assessment_Site__c, "Ridgewood, NJ"),
        ISPICKVAL(Assessment_Site__c, "New York, NY"),
        ISPICKVAL(Assessment_Site__c, "Mount Laurel, NJ")
    ),
    ISBLANK(TEXT(Must_obtain_labs_prior_to_assessment__c))
)

All Answers

Deepak AnandDeepak Anand
Close. Try this = 
AND(
    OR(
        ISPICKVAL(Assessment_Site__c, "Ridgewood, NJ"),
        ISPICKVAL(Assessment_Site__c, "New York, NY"),
        ISPICKVAL(Assessment_Site__c, "Mount Laurel, NJ")
    ),
    ISBLANK(TEXT(Must_obtain_labs_prior_to_assessment__c))
)
This was selected as the best answer
Deepak AnandDeepak Anand
Alternatively - 
AND(
    CASE(
        Assessment_Site__c,
        "Ridgewood, NJ",    1,
        "New York, NY",     1,
        "Mount Laurel, NJ", 1,
        0
    ) = 1,
    ISBLANK(TEXT(Must_obtain_labs_prior_to_assessment__c))
)
Teri CurtinTeri Curtin
Worked Perfectly.  Thank you!