I cant seem to figure out how if the user selects overdue from the drop down it will show all tasks that have dates < today. I’d also like the other select options (Open, In progress) etc to show tasks that are tagged with the status relevant to the drop down item. Is it possible to build out a filter this complex?
I don’t actually think you can. What I would do is:
Create a column (checkbox type) called Overdue, that has a formula in it. IF thisRow.due Date < Today(), true, “”.
Meaning that if the due date of that row is earlier than today, the checkbox is checked. You can hide that column from the main table view, but still filter by it. So now you will have an Overdue filter with a YES or NO.