You need to sign in to do that
Don't have an account?
validation rule for picklist value....
Hi All,
i need to create one validation rule..

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
i need to create one validation rule..
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
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
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
Thanks for your reply..........
V Varaprasad