1
00:00:00,080 --> 00:00:03,920
Our fictional tracker has six tasks, including one due today, one

2
00:00:03,920 --> 00:00:08,457
closed task with a past date, and one open task with no date.

3
00:00:08,457 --> 00:00:11,599
A red highlight alone can be easy to miss.

4
00:00:11,599 --> 00:00:15,439
We will build a separate FILTER result that shows only tasks

5
00:00:15,439 --> 00:00:20,325
that are both overdue and still Open, then compare IDs against an independent answer.

6
00:00:20,925 --> 00:00:24,389
Paste the practice CSV into a disposable Google Sheet.

7
00:00:24,389 --> 00:00:29,008
Put the actual date October twenty-sixth, twenty twenty-six into H1,

8
00:00:29,008 --> 00:00:31,317
rather than typing a text label.

9
00:00:31,317 --> 00:00:35,551
Check that due dates in column C are date values; ISNUMBER

10
00:00:35,551 --> 00:00:37,476
on C2 should return TRUE.

11
00:00:37,476 --> 00:00:41,710
The fixed H1 makes this exercise reproducible even when you watch

12
00:00:41,710 --> 00:00:43,634
the lesson on another day.

13
00:00:44,234 --> 00:00:47,963
A row qualifies only when its due date is before H1,

14
00:00:47,963 --> 00:00:51,693
its status equals Open, and the date cell is not blank.

15
00:00:51,693 --> 00:00:55,761
The due-today row must stay out because before means strictly less

16
00:00:55,761 --> 00:00:57,795
than, not less than or equal.

17
00:00:57,795 --> 00:01:00,508
A closed past-due row also stays out.

18
00:01:00,508 --> 00:01:04,237
Read these conditions before copying the formula, so a plausible-looking

19
00:01:04,237 --> 00:01:06,271
output cannot hide the wrong logic.

20
00:01:06,871 --> 00:01:11,240
Choose an empty result area and enter the exact formula shown.

21
00:01:11,240 --> 00:01:14,814
Google Sheets FILTER returns rows meeting all supplied conditions.

22
00:01:14,814 --> 00:01:19,977
The row conditions have the same six-row height as the A2:D7

23
00:01:19,977 --> 00:01:22,757
source range, which avoids a dimension mismatch.

24
00:01:22,757 --> 00:01:27,125
If the formula spills over existing cells, move it or clear

25
00:01:27,125 --> 00:01:29,111
only the disposable output area.

26
00:01:29,711 --> 00:01:35,076
The result should contain T-101 followed by T-104 and no other rows.

27
00:01:35,076 --> 00:01:40,058
Check that T-102 is excluded because it is Closed, T-103 because

28
00:01:40,058 --> 00:01:45,807
its deadline is today rather than earlier, and T-105 because it has no deadline.

29
00:01:45,807 --> 00:01:51,556
This near-miss check catches errors that a simple count of two would not reveal.

30
00:01:52,156 --> 00:01:55,948
For a live tracker, H1 can contain TODAY so the view

31
00:01:55,948 --> 00:01:57,672
changes when the spreadsheet recalculates.

32
00:01:57,672 --> 00:02:01,465
Google notes that TODAY is volatile and reflects the last recalculation,

33
00:02:01,465 --> 00:02:03,878
so the answer can change with time.

34
00:02:03,878 --> 00:02:07,671
Keep the fixed date for practice and document the reporting time

35
00:02:07,671 --> 00:02:09,739
zone in a real team workflow.

36
00:02:09,739 --> 00:02:14,566
If no rows match, FILTER may return an error instead of a blank table.