#1
|
|||
|
|||
Filter - Late Tasks
Morning! Yesterday I filtered out 'Late Tasks' using View>Data>Filter>Late Tasks (a predetermined filter). Is there a way to see the parameters of that filter? If not, can you tell me why it would show a task with a Finish date of, for example, 7/23, as being 'late' ? Even a task with 8/1 appears, 6/13 etc. For the most part, it provided me a list of items that are past due- but it also included tasks that started prior to today's date, but ends after today's date. The only explanation I can come up with as to why it may provide me with that information, is that the tasks are still at "0%" complete. I haven't marked the task as 'being on track' or provided any update to the status of the task itself- therefore, maybe, Project thinks the task is on track to be late.. ?? And is providing me information to be proactive in ensuring that they don't end up being late? Any information would be great! I filtered this yesterday in order to review with the Principal of the project, and identify if the tasks were actually completed and no one had updated them accordingly. Thanks! E |
#2
|
|||
|
|||
Instead of selecting the filter from the drop-down, select More Filters from the bottom of the list to open the More Filters dialog. Select the Late Tasks filter and click the Edit button. The Late Tasks Filter uses the Status field to indicate whether a task is future, on schedule, or late. The definitions used are:
If the task start date is greater than the status date, then the Status field contains Future Task. If timephased cumulative percent complete is spread to at least the day before the status date, then the Status field contains On Schedule. If the timephased cumulative percent complete does not reach midnight on the day before the status date, then the Status field contains Late. So, my guess is as you have not updated the task its percent complete is not where it should be. It is not based on Finish dates alone. |
#3
|
|||
|
|||
Gotcha.
In the meantime I had generated a "behind schedule" filter instead, that fit my requirements. I suppose I could just use that going forward, since the tasks are not updated based on status date (currently). It's a very simple filter- just set it up to tell me the tasks that are past their expected finish date, and are less than 100% complete. Thanks for the explanation. E |
#4
|
|||
|
|||
Great. Glad you have what you need and thanks for the feedback.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
filter 'Task name' shows all tasks | Intruder | Project | 5 | 02-02-2014 07:29 AM |
Adding field in word in header in a bookmark in table with Excel vba Late Binding | Hdr | Excel Programming | 6 | 02-11-2013 02:58 AM |
updating not completed tasks or 0% tasks | ketanco | Project | 3 | 08-24-2012 05:59 AM |
Late Binding on SHDocVw | tinfanide | Excel Programming | 1 | 05-19-2012 10:00 PM |
Export Excel tasks into Outlook Tasks (2007 Version on both) | crazedmom | Excel | 0 | 12-29-2011 07:55 AM |