Reports Book Not Working

grant53396 ✭✭
edited 12/09/19 in Smartsheet Basics


Not sure if anyone can help me on this, as Support haven't responded after emails sent 3 weeks ago...

I have created a report that pulls in information from different sheets, on specific criteria. when i set this criteria in the filters section on each individual sheet, i return 243 results from all 3 sheets combined together. However, when i run the report, with the same criteria, i only get 120 results in total! also, the information is all muddled up, as it doesnt actually meet the criteria set when you delve into it!

Not sure if anyone has experienced this or know what may be causing the bug?