You need to sign in to do that
Don't have an account?
Farhan Noor
Multiselect picklist validation rule
Need help to write a validation rule for multiselect picklist
For example Multiselect picklist Colour_c
Green
Blue
Orange
Red
So if user select one or more value from Colour_c the other picklist field shape_c become required
picklist Value shape_c
Square
Circle
Rectangular
For example Multiselect picklist Colour_c
Green
Blue
Orange
Red
So if user select one or more value from Colour_c the other picklist field shape_c become required
picklist Value shape_c
Square
Circle
Rectangular
Use below formula,
Note: replace you multipicklist value in test,test1,test2,test,3,test4
AND(
ISBLANK(TEXT(RequiredFieldPickListname)),
OR(
INCLUDES(multipicklistname, "Test"),
INCLUDES(multipicklistname, "Test1"),
INCLUDES(multipicklistname, "Test2"),
INCLUDES(multipicklistname, "Test3"),
INCLUDES(multipicklistname, "Test4")
)
)
Hoep this will help you,
Mark Best ANSWER if its work for you
Thanks
karthik
All Answers
Use below formula,
Note: replace you multipicklist value in test,test1,test2,test,3,test4
AND(
ISBLANK(TEXT(RequiredFieldPickListname)),
OR(
INCLUDES(multipicklistname, "Test"),
INCLUDES(multipicklistname, "Test1"),
INCLUDES(multipicklistname, "Test2"),
INCLUDES(multipicklistname, "Test3"),
INCLUDES(multipicklistname, "Test4")
)
)
Hoep this will help you,
Mark Best ANSWER if its work for you
Thanks
karthik
Your formula will be simply like this
Hope that helps !
Kindly mark it as an answer if it works !
If yes then we can try something like this:
OR(
AND(
NOT(ISBLANK(Colour_c )),
ISBLANK(TEXT(Shape_c)
),
AND(
ISBLANK(Colour_c ),
NOT(ISBLANK(Shape__c))
)
)