Formula help combining and counting two conditional columns
Please help! I am Trying to count the total number when criteria is meet between two different columns. Each column has more than one answer option to include. Priority column can be answered Highest and or 5, Status Column can be answered either new or to do. Here is my formula among multiple others I have tried with no success. I also tried using a + in the equation as well and was unsuccessful.
Both columns need to include at least one of the answer options in order to include in the count;
=COUNTIF({SheetA|Priority}, OR(@cell = "Highest", @cell = 5), AND({SheetA|Status}, OR(@cell = "New", @cell = "To Do",)
Thanks!
Answers
-
Try:
=COUNTIFS({SheetA|Priority}, OR(@cell = "Highest", @cell = 5), {SheetA|Status}, OR(@cell = "New", @cell = "To Do")
-
Perfect! This works, thanks so very much Nic!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!