function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
nickfs92840nickfs92840 

Validation Rule for picklist...

Hello,

 

Looking for a validation rule when the "Effective Date" field is completed, the picklist field "Network Update Completed" must be selected as yes.

 

Currently have a validation rule in place when "Network Update Completed" is selected Yes and the Effective Date is left blank, will prompt the user to enter the date.

 

But, if a user selects No, they can enter a date, but I don't want the date to be entered when No is selected. Only when Yes is selected must a user enter an effective date.

 

Is there a way that if a user does select No and try to enter an Effective Date, they be prompted to change the Network Update Completed to Yes, in order to save the record?

 

API Names:

- Network_Update_Completed__c

- Effective_Date__c

 

 

 

 

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/
I don't know why I continue to answer these after all the beer you owe me...  ;-p
AND(
NOT(ISBLANK(Effective_Date__c)),
NOT(ISPICKVAL(Network_Update_Completed__c, "Yes")))

 

All Answers

Steve :-/Steve :-/
I don't know why I continue to answer these after all the beer you owe me...  ;-p
AND(
NOT(ISBLANK(Effective_Date__c)),
NOT(ISPICKVAL(Network_Update_Completed__c, "Yes")))

 

This was selected as the best answer
nickfs92840nickfs92840

Yes!!! I do owe you what, a Keg by now? lol

 

Thank you once again!!!