How can I pull data from a multi select drop down column?

TinaR

I created a multi select drop down column for my team to select project types. Now I need to pull the number of each project type and summarize it into a graph or chart. How can I do that?

Paul Newcome

You would create a table with the various project types listed out in a column. You would then use a COUNTIFS/HAS combo to get your counts.

=COUNTIFS({Source Data Project Types Column}, HAS(@cell, [Metrics Sheet Project Type Column Name]@row)

Then you can reference this metrics data in your chart widget on a dashboard.