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

Laura
Laura ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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!

 

 

pastduereport.png

Comments

  • J. Craig Williams
    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

  • Laura
    Laura ✭✭✭✭✭✭

    Craig - I edited the above, maybe that clarified it a little more if you feel like youre missing something.

    Or maybe I'm just brain dead this week and everything will be clear to me on Monday? haha Smile

     

    I'm Not using a webform.

    and yes, I am using Dependencies.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Laura,

     

    Are you looking for a Report that shows BOTH Type 1 and 2 or only Type 2?

     

    Craig

  • Laura
    Laura ✭✭✭✭✭✭

    Only Type 2. Sorry!

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Laura,

     

    I think this can't be done in the Report Builder.

    The one that that is a missing, I believe, is "not blank" in the What? criterion.

    The only way to get a  "not blank" is to select "blank" and then exclude it.

    But that excludes all items, not only one of them.

    And we can't have the same % Complete column used in two different criteria, one using exclude and the other not using it.

     

    Looks like you'll need to build your criteria in a formula on your sheet and the Report off that.

     

    Craig

This discussion has been closed.