How can I exclude a task(s) from my report if the predecessor for that task is not complete?

Tim Lebel

I have a dozen or so proejcts each with their own sheet.  I've created a simple report that looks at each project and returns tasks that meet two criteria:

1.  The task has not been marked complete

2.  The task has a due date of 5 days or less.

 

This report works fine, but it returns more data than I want to report on.  Specifically, it reports on tasks that are dependent on other tasks being completed.  I only want to report on the first task (earliest due date) in a chain of dependent tasks.  

 

Thank you,

Tim

Travis

Hi Tim! Reports are designed to bring in rows based on criteria in a single row. 

 

In your sheet, you could build a formula that checks the row above for completion (this would work if your tasks are in sequential order and you dont sort/rearrange). 

 

The formula could look like this (located in row 6):

 

=IF(Status5 = 1, 1, 0)

 

This checks the status on row 5 (flag column) and if the task is complete (flagged) then the formula displays a 1. If the task is not complete, it shows a 0. This criteria could then be used as a report criteria. 

Judith Blanken

For me the same problem. But if I have done like you recommended I can not build the report correctly.

Because

 

1. Status must be NOT completed 

2. Status of predecessor task MUST BE completes

 

If I make a report like this only the rows are showed which status NOT completed AND (or OR) predecessor task MUST BE completes. But i Like to have a repport wiith both

So I like to have in the report

 

Rows which not completes but IF there is a predecessor task than only if the extra collumn shows a 1 (predecessor task is completed)

 

How can I build that report?

Travis

Judith, there would have to be something in your row that indicates the predecessor is completed. You could use a formula to check a box or set a status if the predecessor is complete - then use this in your report. This would be easy if all your rows/predecessors were consecutive but would take a little longer to set up if they are not.