Counts of values in a multi-select column

Shawn Borror

I'm trying to count the number of values in column that allows for multi-select.

In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of contract types.

Paul Newcome

The @cell reference just tells the formula to look at each cell within the range individually. The reason you are returning unparseable is because of the square brackets around your cross sheet reference. Removing those to leave only the curly brackets should do the trick for you.

Alejandra

Hi @Shawn Borror,

I found a great example of a formula that counts the number of times a specific value appears in a multi-select dropdown list column in this community post here: https://community.smartsheet.com/discussion/comment/233516#Comment_233516

I hope this helps!

Paul Newcome

In addition, if you are wanting to count how many times a specific type appears even if there are others selected within the same cell, you would use the CONTAINS function instead of the HAS.

=COUNTIFS([Multi-Select]:[Multi-Select], CONTAINS("contract type", @cell))

The HAS function will only count exact matches, so if you are looking for how many cells have that contract type ONLY and no others selected, then the HAS function would be the way to go.

Shawn Borror

What does the @cell represent here?

=COUNTIFS([{Legal Work Queue Range 6}], CONTAINS("contract type", @cell="MDA")

This returns unparsable...

Paul Newcome

The @cell reference just tells the formula to look at each cell within the range individually. The reason you are returning unparseable is because of the square brackets around your cross sheet reference. Removing those to leave only the curly brackets should do the trick for you.