Reports Book Not Working
Hi,
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?
Comments
-
Hi Grant,
Can you share some screenshots or the sheets/reports? Otherwise, it will be difficult to help you.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi,
Bit difficult to explain without going into the detail of how everything links together, but i have attached pictures of the criteria set in the report builder, and the filters i set in each sheet. I think they should produce the same results, but they dont, as explained above.
Does this make sense?? Sorry, not too sure how to explain!!
-
It looks like the Job Pack Completion Date and the Actual Engineering Completion (Date?) is what's causing the discrepancy.
Is that the case?
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you very much Andree; that is exactly it
They are very similar dates in my head, which is why that was not even registering!! Apologies for the stupid mistake!!!
-
Happy to help!
No need to apologize. It's easy to miss. We've all been there.
Have a fantastic week!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives