Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2014, 05:22 AM
EC37 EC37 is offline Filter - Late Tasks Windows 7 64bit Filter - Late Tasks Office 2010 64bit
Advanced Beginner
Filter - Late Tasks
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-10-2014, 08:29 AM
JulieS JulieS is offline Filter - Late Tasks Windows 7 64bit Filter - Late Tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 06-10-2014, 01:01 PM
EC37 EC37 is offline Filter - Late Tasks Windows 7 64bit Filter - Late Tasks Office 2010 64bit
Advanced Beginner
Filter - Late Tasks
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 06-12-2014, 08:57 AM
JulieS JulieS is offline Filter - Late Tasks Windows 7 64bit Filter - Late Tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Glad you have what you need and thanks for the feedback.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter - Late Tasks 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft