Trying to do a CountIFS and add a date range


I am working on a Summary Sheet and I am trying to add three options together to get a count. I have the first two but not sure how to add a date range. An example is below:

For an Assigned Activity, Status for Q1. So far, I have the Activity Name, the Registration Status but I can’t figure out how to get a date range (since my sheet is year to date) from one column

The Attempt End Date is the column name, but I need a range from 1/1/20 – 3/31/20 and then again from 4/1/20 – 6/31/20. Am doing wrong (like need a separate column)? Thank you

=COUNTIFS([Activity Name]:[Activity Name], "Kronos Employee Series - Open Timecard", [Registration Status]:[Registration Status], "Completed")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!