Ask Search:
Sara JonesSara Jones 

Validation Rule to make date field mandatory based on picklist value selected?

Can anyone help with a formula?
Best Answer chosen by Sara Jones
Leonard SilonLeonard Silon
    AND(
              ISBLANK(date field),
              ISPICKVAL(pick list field, "value")
   )

this will fire the VR and not allow saving          

All Answers

Leonard SilonLeonard Silon
    AND(
              ISBLANK(date field),
              ISPICKVAL(pick list field, "value")
   )

this will fire the VR and not allow saving          
This was selected as the best answer
Steve MolisSteve Molis
Can you provide the API Field Names and picklist values?  

your basic, plain vanilla Formula would be something like
 
AND(
NOT(ISBLANK(TEXT(Picklist))),
ISBLANK(Date)
)
or
IF(ISBLANK(TEXT(Picklist)), 0, 1) 
<>
IF(ISBLANK(Date), 0, 1)


 
Sara JonesSara Jones
Hi Steve,

I used 

AND(
              ISBLANK( Follow_Up__c ),
              ISPICKVAL( Status , "Nurture")
   )

And it worked like a charm :) thanks!!
 
Steve MolisSteve Molis
Good job!  

Don't forget to show Leonard some love and hook the brother up with a Best Answer on his solution
User-added image
Leonard SilonLeonard Silon
Awesome Thank you Leonard Silon Senior Salesforce.com Manager [cid:image001.png@01D3435B.D4F22400] [cid:image002.png@01D3435B.D4F22400] [cid:image005.png@01D3435B.D5070B90] Create a Retail Salesforce Support Case Create an Institutional Salesforce Support Case