Count Multi-Select Options

Jaime Ciabattoni

Hi Community,

I have a multi-select column where I need to count the number of values selected (just the total, not individually). Is there a formula to help with this?

Below is a screenshot of my cell (Rollover) and the outcome I'm looking for (Months Rollover).

Thank you as always!
~Jaime 😀

Protonsponge

Hello @Jaime Ciabattoni

Would this work for you - =COUNTM([Multi Select Drop Down]@row)

The below is from LINK

COUNTM Function:-

Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.

Protonsponge

Hello @Jaime Ciabattoni

Would this work for you - =COUNTM([Multi Select Drop Down]@row)

The below is from LINK

COUNTM Function:-

Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.

Jaime Ciabattoni

Yes! Thank you @Protonsponge!

Protonsponge

Great, pleased you got something that worked for you.

I'm grateful for the opportunity to help you out,

Protonsponge