COUNTIFS and Date Range

Hi

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 : https://help.smartsheet.com/functions but hit a brick wall. Any recommendations on what function I should use?

Thanks.

Lindsay

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!