Counts of values in a multi-select column

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Counts of values in a multi-select column

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.

Answers

  • 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 NewcomePaul 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.

  • edited 02/17/20

    What does the @cell represent here?


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

    This returns unparsable...

Sign In or Register to comment.