Past Due Reports

Laura

GOAL - Tasks Past Due Report for Multi Sheets

 

I have several sheets with the columns set up as seen below: 

 

 

(Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and  % Complete is not required so it's left Blank.

(Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column is left blank because its not required, and the % Complete is required. 

 

I need a report that shows when the End Date on the (Type 2) Rows is past due. I have the Report Builder Set up as: 

Who - Assigned To is not Blank

What - % Complete is not blank and not equal to 1

When - End Date - is in the past

 

My Problem - If the % Complete is blank it gets filtered out.... this is needed because the (Type 1 ) Rows will all be left blank, so filtering them out is correct. I need (Type 2) Rows only to show in the report if % Complete is blank or not 100%.

 

Example: If someone has a task they havent started but is now past due, it will not show up on my report because the % complete is blank. I could ask everyone to enter 5% to acknowledge their task if i HAVE to but I'm trying to find a work around before I go that route.

 

Has anything had this sort of situation? Advice?

 

Thanks!

 

 

J. Craig Williams

Laura,

 

Since [Required] is blank when [% Complete] should not be, you will need a value in the cell.

If adding new rows via a WebForm, set the default value = 0.

If not using Dependencies, you can set the value with a formula.

If you are using Dependencies, you will need to set them manually when setting up the sheet or adding the row.

 

It seems that either the symbol is there (show) or it isn't.

In that case, if the % complete is blank it is an mistake.

 

I think I am missing something.

 

Craig