Formula to display items that have more than one value selected in a custom multi select field

Question

I need help with creating a search to display only items that have more than one value selected in a custom multi select field. Is that a possibility via a formula?

Thanks.

Answer 1

Try Below Formula

LENGTH({custitem25}) - LENGTH(REPLACE({custitem25},',', ''))

Note: If your Multiselect field value does't contains comma.

If comma not there in your multiselect Field then it is working fine

Answer 2

The folllowing is just a case of using that formula as the condition to check and use the usual WHEN/THEN/ELSE as usual around it.

CASE WHEN LENGTH({user.custentity_zel_ae_sales_team.id}) - LENGTH(REPLACE({user.custentity_zel_ae_sales_team.id},',', '')) > 1 THEN 'MORE THEN ONE' ELSE 'ONLY ONE' END