Hi, I want to use Outlook as a work flow system. Meaning I want to creat a task or to-do and have the following basic columns "Task Name", "Status Column", "Start Date" and "Due Date".
When I sort I want to see everything due first. Which means if the "Status" column is Not Started then the "Start Date" is the Column to sort by. But if the "Status" column says In Progress then the "Due Date" is the column to go by.
So the only 2 ways I can think to do this are to either have a custom column that has the Start date if the "Status" column is Not Started and the Due Date if the "Status" column is Not in Progress.
The second way would b to have a custom filter in the Manage Views.
I don't care how it is done I just want to see what I need to do next. And the date is deceptive because the task may have already been started.
I would also love to hear of any ideals you may have to be better organized in Outlook.