function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sumit dsumit d 

Create a validation rule that requires this field when “Other” is selected

 Hi All,
        i have a Picklist field ACH Provider on Account which has some values. now i want to create a validation rule on this field when 
ACH provider == 'Other' ,and the Account Record type == 'Cachet' than it should give error.
how to make this validation Rule?
Best Answer chosen by sumit d
Khan AnasKhan Anas (Salesforce Developers) 
Hi Sumit,

Greetings to you!

Try this: 
AND( 
$RecordType.Name = "Cachet", 
ISPICKVAL(ACH_Provider__c, "Other"))

Use correct API name for picklist field.

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas

All Answers

Khan AnasKhan Anas (Salesforce Developers) 
Hi Sumit,

Greetings to you!

Try this: 
AND( 
$RecordType.Name = "Cachet", 
ISPICKVAL(ACH_Provider__c, "Other"))

Use correct API name for picklist field.

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
This was selected as the best answer
sumit dsumit d
Hi ,
Thanks it helps.