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