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

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)))



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

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




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.