Filter for rows that are due to day and in the past
I want to be able to filter a sheet to show the rows that are due to today and any that are overdue, i.e. in the past. i have a column called due date and another called status which is either started or complete.
the filter i have on is 'status = started' and 'due date = today' . however i would want to filter on 'due date = in the past' as well so that i can see tasks that are open which are due today or overdue. using 'at least one condition' does not work for this. any thoughts?