Forum Discussion
Highlight tasks ahead of schedule
Hi,
We have a programme created in Project, we have applied a progress line which shows when we are on or behind schedule, but there are a few tasks where we are head of schedule - is there a way of highlighting these?
We're using Project 2013 if it matters!
Thanks
4 Replies
I've got a https://youtu.be/dxsp6x9dD98 on highlighting late tasks using bar styles, which you can adapt to show tasks that are ahead of schedule.
Alternatively, you can set-up a Custom Flag field to display a green icon using the formula IIf( [Finish Variance]< 0,Yes ,No)
- TomHawes --
Interesting question. Challenge accepted. There is no default method for locating tasks whose progress is ahead of schedule, but it can be done using two custom fields. Do the following:
1. Create a new custom field using the Date1 field and name it something like Status Date 2.
2. In this field, enter the following formula: [Status Date]
3. In the Calculation for Task and Group Summary Rows section of the dialog, select the "Use formula" option, and then click the OK button.
This custom field will capture the Status Date value that you set. Now, set the Status Date for your project. Ideally, this should be the last day of the last reporting period, which is normally a Friday, Saturday, or Sunday. My solution depends on you setting a Status Date each week. Also, enter task progress in your project if you have not done so already.
4. Next, create a new filter named something like Progress Ahead of Schedule.
5. Create the custom filter using the following criteria:
Stop Is greater than Date1
6. Select the "Show related summary rows" checkbox and then click the OK button.
When you apply this filter, the result will be every task whose progress is LATER than the Status Date of your project. The Stop field, which is used in this formula, is calculated by Microsoft Project as the date on which progress ends for each task. Hope this helps.- That's great
I was thinking someone might know about tick box somewhere I'd missed or something - I didn't think anyone would go to all that trouble so I really appreciate it - thank you 🙂- TomHawes --
You are more than welcome for the help, my friend! You now know it was more than a checkbox setting! HA! Don't feel bad for the time I spent writing you the reply. I would actually like to use this problem in a future YouTube video. I can assure you that the solution to your problem is one that most Microsoft Project users would have NEVER figured out! 🙂
