+ Start a Discussion
force shahidforce shahid 

Validation rule on Picklist field ?

Hi friends,

I want to create a validation rule on picklist field , that is if select morethan one picklist value then display the error message .
pkpnairpkpnair
If you do not want multi pick likst, go for the field type Picklist not Multupicklist.
force shahidforce shahid
Hi,

Changing datatype is not my requirement . My requirement is :
 
  1. If field segmentation has value = FVI system should not allow a user(Sales Rep) to be assigned to more than 1(one) territory.
Then how can I create the validation rule ?
 
pkpnairpkpnair
Check 
IF(INCLUDES(Picklist__c, "A"),1,0) + 
IF(INCLUDES(Picklist__c, "B"),1,0) + 
IF(INCLUDES(Picklist__c, "C"),1,0) + 
IF(INCLUDES(Picklist__c, "D"),1,0) + 
IF(INCLUDES(Picklist__c, "E"),1,0) > 1