Project Plan Reports

swaldon2

Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible?

If not, is there a formula that pulls the task name that I can do?

Paul Newcome

You would need a helper column on each project plan that flags the oldest incomplete task. Then you can create a row report that pulls from all project plans and is filtered to show only the rows that are flagged.

swaldon2

@Paul Newcome Would the "flagging" be manual or is there a way to automate it? Here is a picture of the project plan to help.

Paul Newcome

You can automate it with a formula. I'd be happy to help with one, but there are a number of different ways to interpret "oldest". What is your logic?