Using 'OR' Function within 'COUNTIFS'
Hi, I am having trouble with a formula.
I am trying to count the number of items with a Status of "1.6 QUOTE SENT" AND "2.1 DRAFT", but I'm unable to get the formula to function. I'm having trouble correctly parsing the OR function in the formula:
=COUNTIFS({3. LIVE ORDERS Status}, OR("1.6 QUOTE SENT", "2.1 DRAFT"), {3. LIVE ORDERS Quote Sent}, DATE@row)
The formula works correctly when I am not using the OR status
=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT", {3. LIVE ORDERS Quote Sent}, DATE@row)
Any help would be greatly appreciated.
Thanks!
Answers
-
hey Josh, I think this just needs a slight adjustment:
OR(@cell=“value 1”, @cell =“value 2”)
alternately, you could always just add the output of two COUNTIFS like this:
=COUNTIFS(<criteria 1>) + COUNTIFS(<criteria 2>)
-
Hi Josh S,
You can try the below formula:
=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT") + COUNTIFS({3. LIVE ORDERS Status}, "2.1 DRAFT", {3. LIVE ORDERS Quote Sent}, DATE@row)
I hope it will work, if not, can you please provide the screenshot for context? (Removing any sensitive information)
Thank you!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!