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.

Reports showing wrong criteria

Emma Ibell
Emma Ibell ✭
edited 12/09/19 in Archived 2017 Posts

Hi

I have been using reports for a while now and everything has been working fine however lately they have been including results that do not meet the criteria I have specified.

For example I have a report that's criteria is Column 1 is Yes and Column 2 in not checked that they will appear on the report. However lately the report is showing some results that are wrong. It is showing some that have column 1 as Yes and column 2 is checked.

I have tried writing a brand new report but the same issue is happening. Has anyone else experienced this and if so is there a fix?

Thanks,

Emma

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Emma, 

    Can you share a screenshot of your report builder settings? Usually, when you start getting unwanted results, it's because the report builder settings are set to OR instead of AND. Look there first and see if that is the cause. Sharing a screenshot will help us help you. :)

    · Share on FacebookShare on Twitter
  • Emma Ibell
    Emma Ibell ✭

    Hi

    I've attached a screenshot for you to look at. My criteria is set as AND. The report has been working and only shows some items that are Yes and Checked. So I'm not sure what is wrong with these particular rows.

    Thanks,

    Emma

    Screenshot.JPG

    · Share on FacebookShare on Twitter
  • Scott Medd
    Scott Medd ✭
    edited 08/08/17

    I am having the same issue. I have only noticed today. I updated the source data, and then went into the report to check everything was working smoothly but it hasnt updated

    I am a regular user and this is causing our business serious issues, can someone look into this.

    The attached shows that the criteria has been updated to just one person but the other person is still showing in the results

    screen 08.08.17.png

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Emma and Scott,

    I would recommend sending this directly to support. It is clear that the report builder is not working as intended. That is bizarre. https://help.smartsheet.com/contact

    · Share on FacebookShare on Twitter
  • Emma Ibell
    Emma Ibell ✭

    Scott, I managed to get mine fixed. I changed the data in one cell of each row that was not meant to be on the report, saved, refreshed the report, and then changed the data back to what it was. Once refreshing the report again the wrong results were not showing anymore.

    Don't know how feasible a fix this is for you, I only had a few rows to change so it didn't take that long. I would advise sending yourself a copy of the report before changing anything so that you can easily identify any rows that may disappear from the report and you can change the data back to what it was.

    For example, I unchecked the box in columns that were checked and then unchecked them again and the report was showing me the correct rows again.

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

    · Share on FacebookShare on Twitter
  • Scott Medd
    Scott Medd ✭

    Thanks Mike, I forwarded the problem onto Support. 

    Thanks support this issue has now been resolved for me. Can you let me know when this was identified? Was it through questions coming through? I am concerned because i picked it up but others may not have done which would obviously lead to larger problems.

    · Share on FacebookShare on Twitter
  • Scott Medd
    Scott Medd ✭

    There is a new error on a different report now, this is causing serious issues across the company. Please urgently can this be fixed

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Scott,

    The Support team is better equipped to troubleshoot and resolve these types of issues. Please reach out to our Support team or reply to the existing email thread you have with our support team to troubleshoot your reporting issue.

     

    · Share on FacebookShare on Twitter
  • Adam Beardall
    Adam Beardall ✭
    edited 12/16/19

    I have had similar issues, have sent onto support so hopefully this can be resolved quickly!

    Report Builder:


     

    Report:

    · Share on FacebookShare on Twitter
  • SYSPK
    SYSPK ✭✭✭✭✭✭

    Just happened to me too. Emma's advice above helped.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories