Sign Up ›

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

Formula to see if Multi-Select picklist is Empty

Hi -

I have a formula that's not working, but the "Help" says to use "ISBLANK". I've tried ISNULL and ISBLANK (TEXT(multi-select picklist name).

 

The multi-select field is "Private_Insurance_c"

 

I just need to know if the multi-select field is blank, otherwise, I'll print its contents and the contants of the Private Insurance number field if it is not blank.  Should be simple?

 

IF(ISBLANK(  Eye_Med_Number__c   ) ,"",("  Eye Med #:  " & Eye_Med_Number__c  &  "  ")) &
IF(ISBLANK(Private_Insurance__c  ) ,"",("  Private Ins:  " & TEXT(Private_Insurance__c) &  "  ") &

IF(ISBLANK(  Private_Insurance_Number__c ) ,"",("  Private Ins #:  " & Private_Insurance_Number__c) &  "  "))

 

Thanks -

Sraa