Reply
Contributor
joe27
Posts: 7
0
Accepted Solution

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

Regular Contributor
sourav046
Posts: 75
0

Re: need validation rule

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*/

Contributor
joe27
Posts: 7
0

Re: need validation rule

fair play to you that worked perfect

 

thanks

joe

Regular Contributor
sruthiforce
Posts: 11
0

need validation rule

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)