CountIfs Date Range

Hello! I'm trying to pull the line count on another sheet if the line's completion date is within the start and end date of another sheet. My formula is returning 0 and I'm not quite sure where the issue is coming from.

=COUNTIFS({Accuracy Issue Tracker with Form Range 3}, [Billing Date Start]:[Billing Date Start] <= {Accuracy Issue Tracker with Form Range 4}, {Accuracy Issue Tracker with Form Range 3}, [Billing Date End]:[Billing Date End] >= {Accuracy Issue Tracker with Form Range 4})

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!