Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Past Due Reports
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?