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.

Report - Finish Dates

Wade Harshman
edited 08/08/17 in Archived 2017 Posts

I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow.  (A screenshot of the report builder is attached, below.)  It stopped working properly yesterday, when I updated some dates but the task did not drop from the report.  Today, it's showing tasks that are due a week from now, and it won't properly sort by finish date, the way I prefer.  In my list of tasks (screenshot below), it's showing 8/8, 8/7, 8/7, 8/16, 8/4, 8/15.  I'm sorting by Finish date, so they should be arraged 8/4, 8/7, 8/8, and 8/15 or 8/16 shouldn't even be here.

 

It's always worked until this week, and I haven't changed anything except that I updated some finish dates yesterday.  It's almost as if the values shown are not the data used to generate this report.

 

Any idea why this report is not running properly?   I have a bad habit of overlooking simple solutions.

 

 

 

Capture.PNG

Capture1.PNG

Capture.PNG

Capture.PNG

Capture1.PNG

Capture.PNG

Comments

  • I'm also experiencing this issue, however mine is whether or not a string field is null.  When the user types a "Contact Name" it should drop off the list, however all users presently using this report still have some visibility to the rows in which they have appended a contact name.

    Not sure what the root cause is here, but it doesn't seem to be affecting all of the rows in which they've appended a name.

    Filter not working in report.png

  • Ian
    Ian
    edited 08/08/17

    I am experiencing a similiar issue.  I have a report that should only pull in sheet information with the status of "yellow".



    But over the last couple of days it is randomly pulling in green and blue

  • Hi All,

    Our Support and Development teams are actively troubleshooting an issue they've found with reports.

    Please contact our Support team to troubleshoot further with them.

  • Thanks, Shaine.

    If it helps, I've included a screenshot below of a malfunctioning report.  This should only show Finish dates that are "in the past," but you can see it's showing dates that are today or next week.  (I'm posting this on 10 August.)  

    However, all of these dates have a history that was once "in the past."  The 8/15/17 date, for example, was once 7/25/17.  Perhaps the report is pulling from the cell history, somehow?  I have no idea, just trying to share anything that might help.

     

    Capture.PNG

  • Here's another example from today (14 August)

    A screenshot of my report is below.  When working properly, this report should show me any project tasks I have that are in the past and incomplete.  Today I have 5 items showing up.  4 are in the past and are complete, so they should not be included in this report.  These were marked complete last week; it's almost as if the report isn't accessing that change.

    The 5th item isn't scheduled to finish until Wednesday, 16 August, so it should not be included, either.  This item was scheduled to complete two weeks ago, but was updated with a new date.  Again, the report seems to be ignoring the updated data.

    I hope this helps; let me know if there's anything I can provide to help solve this.

    Capture.PNG

This discussion has been closed.