Formula to show the number of items that meet 2 criteria
I am looking to tally up the number of tasks that meet the following criteria:
- Don't have a check in the column "Done"
- Have a due date within the next 14 days
I am actually going to create 3 buckets (due within the next 14 days from today (whenever it's opened), due between 15 and 30 days and due in over 30 days).
I tried this formula but it's "#UNPARSEABLE". I tried using @row instead of selecting rows 1 - 36 but was having issues with that so I just picked a range for testing purposes.
Any tips where I am going wrong?
=COUNTIFS(Done1:Done36, =0, ([Due Date]1:[Due Date]36, <=TODAY(14))))
Help Article Resources
Check out the Formula Handbook template!