Formula - Count IFS



i am having trouble with a calculation I am trying to use. The formula is :

=COUNTIFS({Original Due Date}, >=[Column22]@row, {Original Due Date}, <=[Column23]@row, {Days for Deviation Closure}, >30, {Days for Deviation Closure}, <61)

The calculation does not give me an error (all results return as 0, however, if I use the filter function with the same parameters I get different results (a different number for each set of dates.

Does anyone happen to see what in the calculation may be prohibiting it to count correctly?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!