Need Help Creating a Filter between Schedule Updates for Delayed Critical Path Activities

I don't think it's doable just with filters -I don't think the baseline late dates are a field you can filter on.

You could probably manage it by exporting your baseline to excel & re-importing BL late dates as user date fields (which are filterable)

Hi Chris,

You'd need to do this in Excel. Try the following steps.

1. Export your baseline schedule to Excel with the following fields: Activity ID, Activity Name, Start, Finish, Late Start, Late Finish & Total Float
2. Also export your live schedule to Excel with the following fields: Activity ID, Activity Name, Actual Start, Actual Finish, % Complete
3. Combine these 2 exports into one workbook with 2 worksheets (tabs): Baseline & Live
4. Add a third worksheet, lets call this Delays and in this third spreadsheet, using a combination of the following functions: IF, VLOOKUP and INDEX & MATCH, display activities from Live worksheet that meet either of the following 3 conditions:
   1. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete equal to 0
   2. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete not equal to 0 and Actual Start greater than Baseline Start
   3. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete not equal to 0 and Actual Finish greater than Baseline Finish

You will need to present your results in Excel.

=jerome

Hi Chris,

First, you need to define your critical activities in >Scheduling Options and second, you can use range or multiple filters to achieved the output you want in P6. If you are referring to the baseline, you can use the baseline start and finish dates and range of 2 weeks from data date.

Regards,

Daniel