#1
|
|||
|
|||
Export list of end tasks only
Hey all
Forgive my noobness. I have only recently started using MSP. I want to export a list of all outdated tasks. I have already set the filters to show that list, but it includes all task headers. Is there a way of only selecting the lowest level tasks. As in, with a WBS, I want to copy the task associated with 1.2.3.4 and not include the task headers of 1.2.3 , 1.2 and 1. I hope I make sense. Thanks Alan |
#2
|
|||
|
|||
Hi Alan
When you export tasks from Project you will always take the Summary Task with your lower level tasks. You cannot just extract low level tasks. However, what you can do in your export map is to include the field called "Outline Level". Then when in Excel you can filter on the lowest level you want to view in Excel using that field as a filter. Hope this helps. Good luck. Tony(OTPM) |
#3
|
|||
|
|||
Thanks, but unfortunately that won't work. At the moment there is no structure to the plans and some go down different levels (e.g. in one section the actual task is level 4 and in another it is 8). So I can't filter that way
Maybe there is an easier way that I don't know. I basically got to give a summary of the amount of tasks that are outdated (finish date is in the past and don't have 100% complete). I can't say there are 400 lines outdated when half of them are the upper levels and not the actual task. Do you know of a way to do that easily?..... in these badly constructed plans :P |
#4
|
|||
|
|||
Hi
Thanks for providing further information on what you need. Basically you can do what you need in MS Project very easily. Simply add an extra field called status to your view. You can then filter on those tasks that are marked as "Late". However don't forget to make sure that you change the Project Status Date to the date you run your report. If you don't update the Project Status date you will not get up-to-date information. If you need further help then come back to the forum with more information. Good luck. Tony(OTPM) |
#5
|
|||
|
|||
Thanks for the help
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Anyone good with Tasks? | colonelcack | Outlook | 0 | 01-20-2011 02:50 PM |
Filtering Tasks | timvb85 | Outlook | 0 | 11-15-2010 08:30 PM |
How do you create a list similar to an itunes list? | hatemail13 | Excel | 1 | 08-06-2010 02:21 AM |
Why red tasks at last 3 tasks of 21 tasks | Jochen | Project | 2 | 04-13-2009 07:29 AM |
Group tasks | grahamsyuk | Outlook | 0 | 09-03-2007 02:31 AM |