Validation rule on multi-select picklist

Hi there,

how can I create a Validation Rule that would ensure that maximum 3 values can be selected out of 6 values available in a multi-select picklist?

Which formula should I use?

Or does this require coding?

Thanks very much in advance,

Stardust

November 11, 2013
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

Satish_SFDC
This link exactly answers your questions.

https://success.salesforce.com/answers?id=90630000000h1cIAAQ

Regards,
Satish Kumar
Please mark my answer as a solution if it was helpful so it is available to others as a proper solution.
If you felt I went above and beyond, please give me Kudos by clicking on the star icon.

November 11, 2013
·
Like
1
·
Dislike
0

This was selected as the best answer

Stardust
Brilliant solution! It works. Thanks Satish_SFDC

November 13, 2013
·
Like
0
·
Dislike
0

Groundwire Consulting
Hi,
Try this below code..

IF(INCLUDES(Fieldname, "value1"),1,0) +
IF(INCLUDES(Fieldname, "value2"),1,0) +
IF(INCLUDES(Fieldname, "value3"),1,0) +
IF(INCLUDES(Fieldname, " value4"),1,0) +
IF(INCLUDES(Fieldname, " value5"),1,0) > 3

and if you have any more questions please feel to contact me on support@groundwireconsulting.com

November 16, 2013
·
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 on multi-select picklist

All Answers

You need to sign in to do that.