This is my first Q post so if I don't provide enough info, let me know.
I have 7 categories of "open" tickets to resolve a software issue. The project name is "SCRM". I am trying to use the COUNTIFS formula to tell me how many open tickets I have against SCRM if an open ticket counts if the criteria is one of the seven categories. This is what I started with and I can't get past the first status of "UAT Testing". =COUNTIFS({System}, "SCRM", {Status}, "UAT Testing", {Status}, "Issue Reported"). The formula works fine until I add the second {Status}.
Thanks in advance.
Answers
-
With COUNTIFS, all the criteria have to be true, so currently your formula is asking for cells that have both the status of UAT Testing and the status of Issue Reported. I believe it should work with an OR function (OR Function | Smartsheet Learning Center) in the second criterion section. Like this: =COUNTIFS({System},"SCRM", {Status},OR("UAT Testing","Issue Reported","Another Status Here","etc"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!