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
joe27joe27 

need validation rule

hi all

 

i need a validation rule for a picklist

 

i have a picklist with A,B,C,D ,,

i need to the make rule say if A,B are picked then a field is then required

 

this is what i was trying

1

AND ( (TEXT(  Board_1__c ) ='A'), (TEXT(  Board_1_Finish__c  ) = null) )

This work only for A ,But i cant B in

2

AND

(ISPICKVAL(Board_1__c, "A"),

OR

(ISPICKVAL(Board_1__c , "B"),

(TEXT

(Board_1_Finish__c  ) = null) ))

any help would be great

 

thanks

joe

Best Answer chosen by Admin (Salesforce Developers) 
joe27joe27

fair play to you that worked perfect

 

thanks

joe

All Answers

sourav046sourav046
AND(OR(text(Board_1__c )="A",text( Board_1__c )="B"),text(Board_1_Finish__c )=NULL)

 This should solve your query .

 

/*If this post answers your  query mark it as resolved*/
joe27joe27

fair play to you that worked perfect

 

thanks

joe

This was selected as the best answer
sruthiforcesruthiforce

how to write validation rule for this:

Make the Reverse Bingo fields required on closing a case if:

(1) Account_Authorization__c contains RASP

(2) Account.Type = SI, System Integrator, Service Provider

(3) Type <> Support Site Admin, License request

 

((1) OR (2)) AND (3)