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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
My apologies! I should have noticed that; yes, you're absolutely correct. I'm glad you figured it out!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
