function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jimjamzjimjamz 

Multi-picklist and field validation and/ or dependant picklist

As per the title,

I have a picklist (ie. stage) and want users to select a multipicklist item when the stage is set to say LOST.

I get a NOT APPLICABLE on the multipicklist field when i enter the page?

Am i doing something wrong?

Another method i thought was to use field validation so that when the stage is changed to 'LOST'
the length of the multipicklist cannot be 0 or   ISNULL(picklist)


does any body know how to get around this and apply some type of validation on the field?
ie. there could be multiple reasons why the opportunity was lost.

cheers, JT
MrDMrD
You may want to try the following Validation Rule:
 
AND(
OR(
ISPICKVAL(Stage_c,"Lost"),
ISNULL(multipicklist)
)
 
Stage_c = The 'Stage' picklist which contains "Lost"
multipicklist = Reason(s) the opportunity was lost.
jimjamzjimjamz
Hi MrD

"Error: Unsupported type Picklist (Multi-Select) of referenced field ReasonforLoss__c"
LibraLibra
I am having the same dilemma.  Not sure if salesforce supports making a multi-picklist populated.
magandrezmagandrez

Hi!,

 

I think the problem come from the ISPICKVAL function. This function doesn't allow to use multi-picklists. Try instead using INCLUDES.

 

I hope it will help.

 

MGA