How to create a formula with multiple criteria with OR logic?
Hi Team,
I would like to create some formulas with multiple criteria where some should work with OR logic. Could you advice if this is possible and how should I proceed?
Example:
From the sample data below, I would like to calculate: How many tasks there is that are being worked on (Task Phase is "Started" or "In progress") and at the same time are assigned to either Jane or Natalie.
Thank you in advance for suggestions!
Answers
-
Hi @Janka,
For your question:
=COUNTIFS(Assigned:Assigned, OR(@cell = "Jane", @cell = "Natalie"), [Task Phase]:[Task Phase], OR(@cell = "Started", @cell = "In Progress"))
Hope this helps, but if you've any problems/questions with it, just post!
-
@Nick Korna Thank you so much! This is super helpful!
Have a great day!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!