I can't seem to get it right. My main list that I use every day is Not Completed and I have it sorted just the way I like, except for Over Due items.
I would like to sort my tasks so that Due Today and Over Due items show at the top of my list.
The way I have been approaching it is to add Due Date to the sort list and then add a filter condition so that it only shows Due Today and Over Due, but I cannot find a way to make this work. Is it possible?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Got it! Almost there :)
Now how I get rid of the Completed Items? They are in the list and if I manually sort on the Completed column to place them at the bottom of the list the sort and filter is perfect. But with any change at all the Completed sort does not stick and they show up back again. Thanks for your help so far, it makes a big improvement for me. :)
Fred
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
I can't seem to get it right. My main list that I use every day is Not Completed and I have it sorted just the way I like, except for Over Due items.
I would like to sort my tasks so that Due Today and Over Due items show at the top of my list.
The way I have been approaching it is to add Due Date to the sort list and then add a filter condition so that it only shows Due Today and Over Due, but I cannot find a way to make this work. Is it possible?
Hi,
Yes, that's possible.
Sort by: Due date
Filter by: "Due date before or equals "0"
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
I had tried that, it only displays the items that are Due Today or overdue. It does not display any items with no due date.
Fred
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
OR
- Due date before or equals "0"
- Due date equals ""
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
Sorry, no dice.
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
I tested it and it works.
Did you put the "OR" on top of it and not an "AND" ?
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
Got it! Almost there :)
Now how I get rid of the Completed Items? They are in the list and if I manually sort on the Completed column to place them at the bottom of the list the sort and filter is perfect. But with any change at all the Completed sort does not stick and they show up back again. Thanks for your help so far, it makes a big improvement for me. :)
Fred
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
AND
...Completed equals false
...OR
......Due date before or equals "0"
......Due date equals ""
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Forum"
Brialliant!! Never in a million years would I have been able to figure this out. Thanks again so much.
Fred Wade
Nova Scotia Canada