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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!