Formula to find how many requests a contact is assigned to
I have a sheet that tracks requests that come through a form. Each request then has a set of tasks that 3 teams need to complete. Within each request, there is 1-4 tasks that a contact can be assigned to. What formula can I use to show how many requests someone is assigned to? Right now I'm using a COUNTIF formula, but it is counting all tasks they're assigned to, where I would want it to only track the total requests they are responsible for.
Answers
-
I found a workaround. I'm having the COUNTIFS formula look for the specific contact name and only 1 of the tasks that would be required from that team. If there is an easier way to do this, I'm always up for learning :)
-
Hey @Taylor Riley
It sounds like a COUNTIFS with multiple criteria is potentially the best way to go, I'm glad you figured it out!
If this isn't working as smoothly as you'd like, it would be helpful to know a bit more about your process... screen captures of your sheet would be ideal, but please block out any sensitive data.
Thanks!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!