What is the best way to make a report that pulls from a very large sheet (14K+ lines)?
My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?
Best Answers
-
Do you have Grouping applied to your Report? Grouping will limit what the report can show:
However if you aren't using Grouping, the Report will allow you to page through all the data, as Paul mentioned:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Reports are not limited to 2,500 lines. If you scroll to the bottom of the report, there should be a link to go to the next page.
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!
-
There is no link at the bottom of the page. I have checked it from my screen and two other colleagues' screens; none of us see a link.
-
Do you have Grouping applied to your Report? Grouping will limit what the report can show:
However if you aren't using Grouping, the Report will allow you to page through all the data, as Paul mentioned:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
I do have grouping which is needed for this report; what is another way to pull a report with this large of a set. That message of 2500 grouping does not appear anymore with the filters I have selected but the report is still limited.
-
I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Thank you. My next question was going to be about grouping but I got tied up with work.
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives