function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SPPSPP 

Multi-select picklist can not be blank based on Stage

Hey everyone,

 

I'm trying to create a validation that is triggered when the Stage, "Closed Lost" is selected, that verifys the Multi-select picklist Field called "Closed_lost_reasons_c" is not blank. 

 

I can't use the IsPickVal like in the normal picklist so I am at a loss.

 

Any help you guys have is greatly appreciated.

 

Thanks everyone!

Steve :-/Steve :-/

Here you go

 

AND( ISPICKVAL(Picklist_Field, "X"), ( ISBLANK( MultiPicklist_Field)))

 

so yours would look like this

 

AND(ISPICKVAL(StageName, "Closed Lost"), (ISBLANK( Closed_lost_reasons_c)))

 

 

SPPSPP
Thanks Stevemo!  That works perfectly.
Steve :-/Steve :-/

No problem, you just owe me one of these ;-)

 

http://www.russianriverbrewing.com/web/brews/plinytheelder.htm 

 

 

SPPSPP

Hahaa. Sounds good to me. Always down for an IPA.. We're up in Marin, how about you?

Steve :-/Steve :-/

Just North of Boston, I got to have some Pliny at The Rickhouse in SF when I was at Dreamforce '09.  but unfortunately Pliny is next to impossible to find out here.  

 

I did have some nice West Coast IPA from Green Flash Brewing at a local BBQ joint a while back. 

Ben Jones, CollabraxBen Jones, Collabrax

I'm trying to do similar example, but not working.

 

AND( ISPICKVAL( StageName , "Closed Lost"),
ISBLANK( Strengths__c ),
ISBLANK( Weaknesses__c ),
ISBLANK( Reasons_Lost__c )
)

 

Strenghts__c and Weaknesses__c are textarea and those work alone.  Once I added Reasons_Lost__c (a Multi-picklist), it isn't working.