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
Best Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
My apologies! I should have noticed that; yes, you're absolutely correct. I'm glad you figured it out!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
You can refer to this discussion - Count Multi Select dropdown values — Smartsheet Community
-
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
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
IT HELPED A LOT!
i just had to change COUNT for COUNTIFS
=COUNTIFS({column_X}, HAS(@cell, "worldcover"))
Thanks!!!
-
My apologies! I should have noticed that; yes, you're absolutely correct. I'm glad you figured it out!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!