Help with COUNTIFS
Trying to count closed cases in a date range, formula won't work:
=COUNTIFS({AAA Range 4}, <= DATE(2021, 8, 01), {AAA Range 4}, >= DATE(2021, 10, 30), {AAA Range 2}, "resolved))
Is there something wrong with my formula?
Tags:
Answers
-
Looks like you're missing close quotes for "resolved" in your formula:
"resolved))
You have an extra end parentheses there when it should be "resolved")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62K Get Help
- 348 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 132 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!