How to get multi-select picklist values in formula field?

In this article, we will talk about how we can fetch multi-select picklist(selected) values in any formula field.

One important point is to considered that we can not directly use TEXT function to convert multi select values into text . You can refer here for more information.

Demo

IF ( INCLUDES ( multipicklist__c , “Value 1” ), “Value 1; “,null ) &
IF ( INCLUDES ( multipicklist__c , “Value 2” ), “Value 2; “,null ) &
IF ( INCLUDES ( multipicklist__c , “Value 3” ), “Value 3; “,null ) &
IF ( INCLUDES ( multipicklist__c , “Value 4” ), “Value 4; “,null ) &
IF ( INCLUDES ( multipicklist__c , “Value 5” ), “Value 5; “,null )

This example would produce return values such as:

Value 1; Value 2; Value 3; Value 4; Value 5;
Value 1; Value 4; Value 5;
Value 2; Value 5;
Value 4;

Hope you find this post useful! Catch you in the next content.
And thank you for being an awesome reader.
Share and grow together !!

If you have any doubts you can comment down below, I will try to reply ASAP.

Also keep visiting us, for more such content!