Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nat SavNat Sav 

Validation rule for Picklist

Hi Team,

could you please to understand why the validation rule doesn`t work:

AND
(ISCHANGED(Stage_test__c),
TEXT(Stage_test__c) != Status__c)

I want to check Account Stage and Status, and if they are not equal, display an error message.
Without part ISCHANGED(Stage_test__c) this rule works, but we should check values only in case if the Stage was changed.
Status - formula(text) in our case, and Stage - picklist.

Thank you,
Nataliia
Best Answer chosen by Nat Sav
Jega DeivaJega Deiva
Hi
   
  Please refer the below link
     https://success.salesforce.com/answers?id=90630000000iAYPAA2

Thanks
Jega
Sweet Potato Tec

All Answers

Raj VakatiRaj Vakati
Try this
  
AND(
ISCHANGED(Stage_test__c),
TEXT(Stage_test__c) <> TEXT(Status__c)
)

 
Nat SavNat Sav
Thank you, but it doesn`t work, Status__c - it`s a formula.
Jega DeivaJega Deiva
Hi
   
  Please refer the below link
     https://success.salesforce.com/answers?id=90630000000iAYPAA2

Thanks
Jega
Sweet Potato Tec
This was selected as the best answer
Nat SavNat Sav
Thank you, it helped.