Associate a Value to count from multiple entries
SkiPatrolScott
✭✭✭✭
=COUNTIFS({ARA routehelpcnt}, ROUTES@row
The count in the above PIC is generated from the formula above.
This sheet pulls from another sheet, sometimes a patroller will be doing two routes at the same time, so the assignment might be STRAW 1 STRAW 2, in the same cell
I would like to credit STRAW 1 with an additional count and STRAW 2 with an additional count. If I enter as is, neither gets credit.
Answers
-
Try: =COUNTIFS({ARA routehelpcnt}, FIND(Routes@row, @cell) > 0)
-
Find did some interesting things, added counts to some and went to zero on others... Because we have some like JP 1, JP 1L it combined these.. thanks for the idea though.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives