Nested criteria
I have this formula but it comes back with a "nested criteria" error message:
COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV") + COUNTIFS([Business Unit]:[Business Unit], OR(@cell = "PRC", @cell = "IFG"), Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV")))
I want to be able to find out how many units come back (stage 3 & 4) that are from business unit MGS in Orange County + how many units come back (stage 3 & 4) from business unit PRC and IFG.
I think I'm close but need a tweak please.
Best Answer
-
Hi @Deb White ,
Try:
=COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV") ) + COUNTIFS([Business Unit]:[Business Unit], OR(@cell = "PRC", @cell = "IFG"), Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV"))
You had 1 paren out of place.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Deb White ,
Try:
=COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV") ) + COUNTIFS([Business Unit]:[Business Unit], OR(@cell = "PRC", @cell = "IFG"), Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV"))
You had 1 paren out of place.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
I was soooo close :) Thank you!
-
1 paren is all that was in your way. Bet it doesn't happen again. Happy to help. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!