How to Count number of boxes checked in a date range, Cross sheet formula

I am needing help with a cross-sheet formula to count the number of boxes checked if the date column is between a certain range. My current formula looks like this:

=IFERROR(COUNTIFS({Checkbox column}, =1, AND({Date column}@cell >= DATE(2022, 9, 1), @cell <= DATE(2022, 12, 6))), "")

however I only get a blank entry or an Invalid Data type entry if I take out the IFERROR part(some rows don't have dates). or an Unparseable. Screen shot of columns below

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!