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.
Best Answer
-
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.
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!
-
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.
-
What does the @cell represent here?
=COUNTIFS([{Legal Work Queue Range 6}], CONTAINS("contract type", @cell="MDA")
This returns unparsable...
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!