COUNTIF between Dates (Children) || Summary

edited 12/09/19 in Formulas and Functions

I have a formula that is troubling me.

I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days).

The forumla below is returning zero. Is it the forumnla or a setting?


The screen cap below is the from the sheet I am using, hopfully it helps as a reference.


COUNTIFS(CHILDREN([Final Approval Date]8), @cell >= DATE(2018, 10, 1), CHILDREN([Final Approval Date]11), @cell < DATE(2018, 10, 31))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!