Forum Discussion
Gantt chart help with late, but active task formatting
As Dr_Edward_Hanna pointed out, you need to tell Project how much progress has been made. That will address your first desire to have expanding progress. However to get your "final wish" you will need to create a custom field and special Gantt bar style to make it happen.
First, create a custom Flag field (e.g. Flag1) using the following formula:
IIf([% Complete]<100 And [Current Date]>=[Baseline Finish],"yes","no")
Second, create a custom Gantt bar Style such as the following:
You could do a normal progress bar up to the Baseline Finish and then have it turn red after if the task still isn't complete, but doing so gets more complex.
Hope this helps.
John
John-project, I tried everything that you show, but it's not working....not sure what I missed.
Further troubleshooting shows that the flag never evaluates to "Yes" (overdue). So there's something wrong with that, though what that is I'm unsure of.
- I noticed that 2 of the bars in the "late" snip (Start and End) were still black, though Middle was red. I tried changing all 3 to red and Start and End will not "stick"?
- Freeboro,
First of all, why are you using manual scheduling? From my view, if you want to do manual scheduling forget Project, do your plan in Excel.
I see you added the new Gantt bar style at the beginning of the list. The Gantt bar style list has a reverse order precedence, that is, bar styles lower in the list take precedence over bar styles at the beginning of the list, if there is a conflict. Could be your new bar style is getting "upstaged" by a bar style lower in the list.
In order to help further with your formula, I'll need to see a screen shot showing the relevant fields such as Start, Finish, Duration, % Complete, Flag 1, Baseline Finish.
JohnBecause I have 6+ people managing projects that I need to consolidate into a summary type doc for my superiors. We were using Excel and I was spending hours per week to sync their top level tasks with my project master. I thought creating a master project doc, and then adding all of theirs as linked sub-projects would fix that and I don't know why the type of scheduling matters?
I've attached a snip. Everything looks like it should to me, but the formula (Overdue?) isn't evaluating correctly.