Salesforce validation rule picklist value not equal to. All parts of the validation rule seem to work, but in testing no Industry picklist value is recognized to be valid. This function doesn’t return default values. I'm trying to create a validation rule that fires if the field is al Sep 19, 2018 ยท However, even when a sales rep chooses "Yes" or "No" from that picklist they receive the error message that the field is required. 1) When you create the workflow rules select "Run this rule if the following" criteria are met instead of formula evaluates to true. The validation rule does not work, as the syntax is incorrect. However, I cannot think how I can express that I want to disallow a certain value if another was selected previously. Thanks again. In order to fulfill the requirement, there are two approaches: To use a Validation Rule to restrict the users to select the picklist values that are no longer needed while creating new records. the result of the formula should be true) if the record type is not equal to all of your 3 allowed options. To allow for requiring the secondary field only when the Other option is selected, you can use a validation rule. yabgrh 4zebdf wboo wwahuzs fzqgwj auki 5se mzoua f4yfm qkvui