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
TarentTarent 

Validation Rule of Picklist

Hi All,
I want three fields should be mendatory once the Stage(picklist) is declined. These three fields are of type Lookup,Text and Number.

Navatar_DbSupNavatar_DbSup

Hi,

 

Try the below validation rule:

 

if( ISPICKVAL(Stage__c , 'Declined/Dead'),

if(Source_Company__c <> null,

if( text(EBIT__c) <> null,

if(Source_Name__c <> null,

false,true),true),true),false)

 

Here Stage__c is picklist, Source_Company__c is lookup, EBIT__c is number and Source_Name__c is of text type.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 
NIKHIL_SFDCNIKHIL_SFDC

Hello,

Here is the validation rule-

 

AND( ISPICKVAL( PickList__c , 'Declined') ,
OR ( ISBLANK( number__c )<>false, Lookup__c =null, ISBLANK( TextField__c )=true)
)