Count if Specific Text within a Date Range


I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. 

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!