+ Start a Discussion
MaheemSamMaheemSam 

Picklist validation not working

Hi, 

  Created below validation in opportunity both are same tried different approach both are not working not sure what is the issue Please suggest. 
AND( 
TEXT(Account.Account_Status__c) = 'Pending', 
OR( 
TEXT(StageName) ='1 - Closed Won', 
TEXT(StageName) = 'Closed - Renewed', 
TEXT(StageName) = 'Booked', 
TEXT(StageName) = 'De-booked' ) )
 
AND(
 ISPICKVAL(Account.Account_Status__c,'Pending'), 
OR(
ISPICKVAL(StageName,'1 - Closed Won'),
ISPICKVAL(StageName,'Closed - Renewed'),
ISPICKVAL(StageName,'Booked'),
ISPICKVAL(StageName,'De-booked')  ) )
Thanks
Sudhir
 
Khan AnasKhan Anas (Salesforce Developers) 
Hi,

Greetings to you!

I have checked this validation rule in my org and it is working fine.
 
AND( 
        ISPICKVAL(Account.Rating,'Warm'), 
        OR( 
              ISPICKVAL(StageName,'Closed Lost'), 
              ISPICKVAL(StageName,'Closed Won') 
        ) 
)

Your rule looks good to me. But, I think that there's a faulty Picklist Value, try removing conditions from the Formula one by one and re-test each time.

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved.

Thanks and Regards,
Khan Anas
MaheemSamMaheemSam
Thanks all for your suggestion it is working my bad i was using a wrong pick list in place of status Account_Creation_Status__c  
Khan AnasKhan Anas (Salesforce Developers) 
Hi,

I’m glad I was able to help! 

Kindly mark this as solved if it's resolved so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue.

Thanks and Regards,
Khan Anas