COUNTIF Formula with 2 Criteria - Status & Checkbox


I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is.

Here is my formula:

=COUNTIFS({1250 Phase 1 Clubhouse Integrated Project Range 1}, "Complete", [{1250 Phase 1 Clubhouse Integrated Project Range 2}, "1"])

When I use the first criteria only on the formula, it works fine, however, I need the second criteria as I only want to count rows with the internal milestone box checked. I've also tried using "true" in place of "1"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!