Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HNT_NeoHNT_Neo 

Picklist Validation Rule when only 1 list item should trigger rule

Hello, 

I have a picklist field, homefree__c, with 4 values, but I only want a validation rule to create an error if only 1 of the list values is chosen; Echo

I tried this, but its not working, please help:
  
TEXT(NOT(homefree__c,"Echo"))

 
Best Answer chosen by HNT_Neo
Raj VakatiRaj Vakati
Hi Neo ,
Use this 

TEXT(homefree__c)=="Echo"

All Answers

Raj VakatiRaj Vakati
Hi Neo ,
Use this 

TEXT(homefree__c)=="Echo"
This was selected as the best answer
Krishnamoorthi PeriasamyKrishnamoorthi Periasamy
Please use ==> ISPICKVAL( homefree__c , 'Echo')
Krishnamoorthi PeriasamyKrishnamoorthi Periasamy
If above answer helps to resolve your requirement, please mark it as "Solved'. Thanks
 
HNT_NeoHNT_Neo
This was a tough one to choose, but thank you both!