Counting tasks throughout the year

Alberto CONCEJAL LÓPEZ

Hi,

I'm counting how many times certain tasks has been added to the list of TO DO of the year,

Meaning for instance if one of my teams (there are 4) has added to the list of day1, task1, and task2 (a different color for every task).

My problem is that it doesnt count unless there's only one task in the cell. If for instance the team1 adds two ore more tasks to the cell, it doesnt count (Ideally i'd need to add a portion of 1, but that's another question).

How am i able to count if there are several tasks in the folder?

Thanks!

Alberto

Genevieve P.

Hi @Alberto CONCEJAL LÓPEZ

It sounds like you're looking for the HAS Function!

HAS will look into a cell to see if it has that one value, even if it's listed with other values.

Try something like this:

=COUNT({column_X}, HAS(@cell, "worldcover"))

Cheers,

Genevieve

Genevieve P.

My apologies! I should have noticed that; yes, you're absolutely correct. I'm glad you figured it out!

Cheers,

Genevieve

Anupriya

You can refer to this discussion - Count Multi Select dropdown values — Smartsheet Community

Alberto CONCEJAL LÓPEZ

Hi, thanks for the try but this only counts something, not sure if the number of cells but

=COUNTM({column_X}, "worldcover")

it returns the same number of items (in this case 275) irrespective the different tasks (worldcover, lodr, etc). Im kind of stuck,

Thanks for your time!

Alberto

Genevieve P.

Hi @Alberto CONCEJAL LÓPEZ

It sounds like you're looking for the HAS Function!

HAS will look into a cell to see if it has that one value, even if it's listed with other values.

Try something like this:

=COUNT({column_X}, HAS(@cell, "worldcover"))

Cheers,

Genevieve

Alberto CONCEJAL LÓPEZ

https://community.smartsheet.com/discussion/comment/316910#Comment_316910

IT HELPED A LOT!

i just had to change COUNT for COUNTIFS

=COUNTIFS({column_X}, HAS(@cell, "worldcover"))

Thanks!!!

Genevieve P.

My apologies! I should have noticed that; yes, you're absolutely correct. I'm glad you figured it out!

Cheers,

Genevieve