Why is the Report function not picking up data from one of the source sheets?

Hi all,

I'm currently using the Reporting function to create a Programme Risk Log for two projects (Project Sample A1 and Project Sample A2), each of which is using the same template Risk Log.

As you will see from the screenshots, both Risk Logs are selected in the Sheets tab for the Report in question, however only data for Project A1 is being picked up.

I have confirmed that there is data in Project A2 and that the sheet has been saved. I have also tried refreshing the report, but the issue remains.

The templates for both projects are identical, so can anyone tell me what I'm doing wrong?

Many thanks and I look forward to hearing from you!

Kind regards,

Gerhard


Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Did you scroll all the way down? Your filter is set to "not equal to minor" which will include those where that field is blank. Is it possible that it is pulling enough blank rows from the first sheet so that it is pushing the rows from the second sheet too low to see without scrolling?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers