I would like to have 2 criteria for the same range
What is wrong with this?
Region Demand needs to be for EMEAR OR Global. I've tried putting OR between EMEAR and Global, but it returns an error unparsable.
If I put in a common it's an incorrect argument. If I break them out seperate with Region Demand same thing.
If I remove Global the formula works perfectly.
=COUNTIFS({EMEAR Global Demand Function}, System@row, {Region Demand}, "EMEAR" "Global")
Best Answer
-
Try this:
=COUNTIFS({EMEAR Global Demand Function}, System@row, {Region Demand}, OR(@cell = "EMEAR", @cell = "Global"))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Try this:
=COUNTIFS({EMEAR Global Demand Function}, System@row, {Region Demand}, OR(@cell = "EMEAR", @cell = "Global"))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you.....works perfectly !!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!