Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Has anyone created a timeline comparison report with color change boxes.

Avatar

Level 2

So i am looking to have a report that shows a timeline comparison between two projects where the task being reported on will turn red if the dates to not align. We have some timelines that are a bit fluid in some cases so i want to find a solution that will help call this out when it happens so the teams can come to the table to negotiate how to proceed and align on what is correct.

I have attached the area in question and am mainly looking at the Kickoff-Market logic approval portion.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

Hi Josh,

One (advanced) approach to monitor the timeline of "Feeder" projects (e.g. Project A) is to create a special section of your workplan (e.g. at the top of Project B, under a "Feeder Projects" parent task, for easy collapse/show convenience) with one task for each such dependency (e.g. "Project A Task XYZ"), with a cross project predecessor (e.g. finish to finish) back to that actual task in the feeder project, but (here's the trick) with no other dependencies or predecessors upon it.

In Project B, you can then set the planned completion date (e.g. to the latest date possible after which -- if Plan A Task XYZ "missed" -- you would then need to then revise the plan; presumably the same as Plan A Task XYZ's real Planned Completion Date, or later, if you have some slack available).

The beauty of this approach is that you can then "see" such Feeder project tasks within Plan B and (thanks to the cross project predecessor) more easily monitor their projected dates as the Feeder Project changes, either on the Gantt view (where a delay on Plan A will then appear, if you turn on Projected Dates, as a "slippage", visually), or (returning to your original question) by highlighting the color of a cell in red whenever the projected completion date is later than the planned completion date.

You can repeat this approach for each Feeder project/task of interest as needed, and for complex systems, even "chain" multiple feeder projects together, which is then where our Timeline solution comes in: it lets you choose one or more Critical Tasks, set their Path Colors, then view Timeline to trace the resulting multiple Critical Paths through all predecessors and feeder projects.

Thanks for raising the question: I'm interested to hear how you make out!

Regards,

Doug

I like this approach let me play around with it and I'll post the results with setup instructions with it.

Thank you!