How can count items in a multi-select column?

Stacy Bourret

I have a project sheet with status and a multi-select column that lists the area(s) each project is for.

I have created a metrics sheet to calculate the number of projects per status per department, however, the columns that have more than one department listed is not being counted. What I am looking for is something like this:

Carson Penticuff

I'm not sure of your sheet names or cross sheet reference names, but this is the general idea. This will give you "Student Services" projects that are in progress.

=COUNTIFS({Source Sheet | Area}, HAS(@cell, "Student Services"), {Source Sheet | Status}, "In Progress")

che.rabajante

Hello @Stacy Bourret

Please try this:

=IF([Multi-Select Column]@row <> "", LEN([Multi-Select Column]@row) - LEN(SUBSTITUTE([Multi-Select Column]@row, CHAR(10), "")) + 1, 0)

Just replace the column name.

Hope this helps.

che

Carson Penticuff

I'm not sure of your sheet names or cross sheet reference names, but this is the general idea. This will give you "Student Services" projects that are in progress.

=COUNTIFS({Source Sheet | Area}, HAS(@cell, "Student Services"), {Source Sheet | Status}, "In Progress")

Stacy Bourret

Thank you Carson! That worked!