Fix Excel Error This Value Doesn T Match The Data Validation Restrictions You're missing a comma in between the arguments to that call to contains. it's true that it's not a parenthesis, but syntax errors in formulas have a tendency to cascade to generate other issues in the end. You could look into vlookup function but it'd require the 3 values all appear in the name field of the object which may be a no go for you. you could write an apex trigger or flow but properly protecting the scenario may be harder than you think.

Help Me With This Validation Rule Error Syntax Error Missing “#error!” displays for a formula field whenever an error occurs while calculating the value of a formula. to resolve the error, check your formula. is the formula dividing by zero? if so, check if the denominator of your expression is zero and provide an alternative value. The validation rule above is missing a ")" since you would have to close out the and statement and the not and isblank also require one, so at the end of this you would need three parens.

Formula Field Validation Rule Inline Comments

Validation Formula Error Types Smart Forms Portal

Validation Formula Error Types Smart Forms Portal

Excel Data Validation Error From Filter Formula Stack Overflow