CountIfs resulting in "0"

edited 12/09/19 in Formulas and Functions

Similar to my previous post, I'm now running into issues with CountIfs returning zeros when I am referencing multiple columns from a separate sheet. I am trying to figure out the number of "Risks" and "Issues" that are marked as state "Complete" each week. I was able to count how many risks and issues have occurred each week, but when I added the "Complete" criteria, smartsheet returns zeros even though I know there are values there. Here is the formula I've been using: 

=COUNTIFS({Date Assigned}, ">=DATE(2019, 03, 25)", {Date Assigned}, "<=DATE(2019,03,31)", {Type}, "Issue", {State}, "Complete")




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!