Count of requests with team member with specific request statuses
sharing below sample data wherein one column I have list of team members and other columns I have status of the requests . Can someone help with formula to find the count of all the requests with Alice having status either In progress and Delayed. I dont want to count Cancelled count.
Resource Request Status
Alice In progress
Alice In progress
joe Cancelled
Tom In progress
Alice Cancelled
Alice Delayed
Alice Delayed
Answers
-
Hi @Shikha Kapoor 3,
You have a few options.
Counting those 2 specific choices (In Progress or Delayed):
=COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], OR(@cell = "In Progress", @cell = "Delayed"))
Counting everything that isn't cancelled:
=COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], <>"Cancelled")
Or as an alternative if you need the details just at a glance, you could also use a report.
Hope this helps, but if you've any problems/questions then just let us know!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!