Validation Rule receiving "syntax error"

We want to create a Validation Rule that excludes records where certain multi-select picklist values do not exist as selected values on the Oppty but, I keep receiving syntax error on this part: NOT(INCLUDES (Sensors__C, ‘1U+ v2’, ‘1U v2’, ‘2U v2’, ‘SFF v2’, ‘TFF v2’, ‘TFF Inline’)).

I've even tried seperating them out but still receive the syntax error...(eek)...

NOT(INCLUDES(Sensors__C, "1U+ v2"))||
NOT(INCLUDES (Sensors__C, “1U v2”))||
NOT(INCLUDES (Sensors__C, “2U v2”))||
NOT(INCLUDES (Sensors__C, “SFF v2”))||
NOT(INCLUDES (Sensors__C, “TFF v2”))||
NOT(INCLUDES (Sensors__C, “TFF Inline”)),

Thank you in advance, y'all!

July 21, 2020
·
Answer
·
Like
0
·
Follow
1

Natalie Gunther
Have you tried using an OR statement instead?
OR(NOT(INCLUDES(Sensors__C, "1U+ v2")),
NOT(INCLUDES (Sensors__C, “1U v2”)),
NOT(INCLUDES (Sensors__C, “2U v2”)),
NOT(INCLUDES (Sensors__C, “SFF v2”)),
NOT(INCLUDES (Sensors__C, “TFF v2”)),
NOT(INCLUDES (Sensors__C, “TFF Inline”)))

July 27, 2020
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Validation Rule receiving "syntax error"

You need to sign in to do that.