Count of Multi Select Options Across Entire Sheet

John Kostenbader

I can find some reference to this that others have asked but it seems slightly different then what I'm looking at. Consider the following:

Column: Type of Issue

A, B, C

A, B

A, D

A, C, D

C, D

I'm looking to place a count of each of the items above on a dashboard across the entire sheet. Any insight would be appreciated

John

Genevieve P.

Hi @John Kostenbader

I believe what you're looking for is the HAS function!

You can use COUNTIF and HAS together to count how many times a cell has a specific value listed.

For example, if you're putting this formula in a Sheet Summary section of your sheet (referencing columns in the current sheet), you would structure it like so:

=COUNTIF([Type of Issue]:[Type of Issue], HAS(@cell, "A"))

Then you can create a Sheet Summary Report to pull together all of your COUNTS and present that Report on your Dashboard.

Or, if you're creating a Metric sheet with cross-sheet formulas, this is the structure:

=COUNTIF({Type of Issue}, HAS(@cell, "A"))

Cheers!

Genevieve

Christina09

@John Kostenbader

Smartsheet has a new features that came out this Aug, you can use report grouping to create chart

https://www.smartsheet.com/content-center/product-news/release-notes/charting-using-grouping-and-summary

John Kostenbader

I looked at this option but according to the help sections for group, the following is true:

Tips and tricks for grouping

Columns with multiple selections, multi-select drop-downs, or contact lists allowing multiple contacts to be assigned to a task cannot be selected for groupings.

that said, I cannot group if a column its set as multi select

Genevieve P.

Hi @John Kostenbader

I believe what you're looking for is the HAS function!

You can use COUNTIF and HAS together to count how many times a cell has a specific value listed.

For example, if you're putting this formula in a Sheet Summary section of your sheet (referencing columns in the current sheet), you would structure it like so:

=COUNTIF([Type of Issue]:[Type of Issue], HAS(@cell, "A"))

Then you can create a Sheet Summary Report to pull together all of your COUNTS and present that Report on your Dashboard.

Or, if you're creating a Metric sheet with cross-sheet formulas, this is the structure:

=COUNTIF({Type of Issue}, HAS(@cell, "A"))

Cheers!

Genevieve