COUNTIFS and Date Range


I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count.

For this count I want to filter on current date date from a range in a column (Current Due Date).

e.g. date range 30/04/2019 to 30/04/2020

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"))

I've been looking at the formula function help wiki for date functions : but hit a brick wall. Any recommendations on what function I should use?




Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!