Nested Crtiteria
Hi,
I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria.
=COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary Column]8, {Owner}, @cell = "Erica"))
Comments
-
You would want to close out your first COUNTIFS then add the second.
=COUNTIFS(.....)
+
COUNTIFS(......)
.
However, you can use OR and AND functions within a COUNTIFS to include multiple or differing sets of criteria for a single range.
Something like this might work for you...
=COUNTIFS({Status}, AND(@cell <> $[Primary Column]7, @cell <> $[Primary Column]8), {Owner}, @cell = "Erica")
-
Thank you,
That worked
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!