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
Best Answers
-
Try this...
=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"), {Date Range}, AND(@cell >= DATE(2019, 04, 30), @cell <= DATE(2020, 04, 30)))
-
@Paul Newcome This worked thank you!
Lindsay
Answers
-
Try this...
=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"), {Date Range}, AND(@cell >= DATE(2019, 04, 30), @cell <= DATE(2020, 04, 30)))
-
@Paul Newcome This worked thank you!
Lindsay
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!