Collect Function with Multiple Criteria

I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!