Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
v varaprasadv varaprasad 

validation rule for picklist value....

Hi All,

i need to create one validation rule..

User-added image

in each prefernce picklist field i have 3 values
primary
ok to contact
do not contact

Among all 6 fields i need to select only one field value is primary....


Any Help really Appreciate...

Thanks
varaprasad

 
Best Answer chosen by v varaprasad
Veenesh VikramVeenesh Vikram
Hi,

Maybe this helps you.

( IF( TEXT(Picklist_1__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_2__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_3__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_4__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_5__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_6__c) == 'Primary', 0, 1) 
) > 1

Regards
Veenesh

All Answers

Veenesh VikramVeenesh Vikram
Hi,

Maybe this helps you.

( IF( TEXT(Picklist_1__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_2__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_3__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_4__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_5__c) == 'Primary', 0, 1) 
+ IF( TEXT(Picklist_6__c) == 'Primary', 0, 1) 
) > 1

Regards
Veenesh
This was selected as the best answer
v varaprasadv varaprasad
Yes I did samething,

Thanks for your reply..........


V Varaprasad