You need to sign in to do that
Don't have an account?
Formula to see if Multi-Select picklist is Empty
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) & " "))