Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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.