# Counting tasks throughout the year

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

• Employee

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

October 8 - 10, Seattle, WA | Register now

• Employee

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

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭
• 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,

Alberto

• Employee

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

October 8 - 10, Seattle, WA | Register now

• IT HELPED A LOT!

i just had to change COUNT for COUNTIFS

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

Thanks!!!

• Employee

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

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!