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

Options
Wade Harshman
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

  • GRM083
    GRM083 ✭✭

    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.

  • Wade Harshman
    Wade Harshman ✭✭

    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

  • Wade Harshman
    Wade Harshman ✭✭

    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.