#Nested Criteria Error, but only on a few rows. What am I doing wrong?
JWells
✭✭
I dragged it down most of them work and pull, but a select few will give me the Nested Criteria Error.
Thank you in advance for any help.
Answers
-
Hello! There is a handy help article for trouble shooting formulas which output error messages. Here is an excerpt related to your Nested Criteria Error:
NESTED CRITERIA
Cause
You’ve nested criteria in a SUMIF or COUNTIF function.
Resolution
Use SUMIFS or COUNTIFS instead, as you can include multiple criteria without nesting.
If your formula works for some rows but not all then there's probably a slight difference in the data being referenced in your formula. Find the difference in your input and it'll point you in the right direction. Hope this helps.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 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