function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

Validation formula requiring date based on picklist value

I need a validation formula requiring entry in a date field based on "Yes" value in picklist.
 
Thanks.
JakesterJakester
Code:
and(
    ispickval(yourpicklist__c,"Yes")
   ,isnull(yourdatefield)
)

 
KimberlyJKimberlyJ
You are fabulous!  Thank you so very much!
JakesterJakester
Glad to hear it worked! :smileyvery-happy:
Collaborative eCollaborative e
Is there a way to hide the date field until "Yes" is selected in the picklist?
JakesterJakester

Not without a major coding effort. The good news/bad news with Salesforce is that you can do a lot of stuff without coding, but as soon as you need to get into coding, it becomes a major effort. That's because you need to write an entire VisualForce page that would replicate everything that the current page does, plus the extra bit about hiding a date field.