count if check box is not checked (2) and requested date is within a date range

Johnnie LaCaze
edited 12/09/19 in Formulas and Functions

I am trying to get a count of each row on my sheet that meets the following criteria. 

Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18


Children of (Canceled17) (which is check box format) is not checked (0)


Children of ([Not Owner]17) (which is a check box format) is not checked (0)


I am currently using this formula to get my monthly count for Requested Date

=COUNTIFS(CHILDREN([Requested Date]$17), @cell >= DATE(2018, 1, 1), CHILDREN([Requested Date]$17), @cell < DATE(2018, 2, 1))

but I need to factor in the criteria above and I was hoping to only have one formula. Is that possible?


Thanks in advance



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!