Is there a different max number for number of rows in a report?
I know the maximums for a sheet (below) but I have a report that only has a handful of columns and is cutting off before all of the data is included (at about 2500 rows). Is there a different maximum number of rows in a report than a sheet?
I am also finding that if I add the grouping feature it will only show the headings in this report until I filter it even further.
Best Answer
-
Actually, we increased this recently! Now you can see up to 2,500 rows per-page on a Report (see this Release Note: Report Page Size)
@Kimberly Loveless, this row limit is per-page, so you should be able to see the rest of your rows by clicking the arrows at the bottom of the screen for the next page. Does that help?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
I hope you're well and safe!
The limit per page is 500 rows in a report.
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Actually, we increased this recently! Now you can see up to 2,500 rows per-page on a Report (see this Release Note: Report Page Size)
@Kimberly Loveless, this row limit is per-page, so you should be able to see the rest of your rows by clicking the arrows at the bottom of the screen for the next page. Does that help?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi, @Genevieve P thank you for the insight I will take a look for the page part, I guess I never noticed it.
-
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.
-
Can anyone explain why in a dashboard only 150 rows can be visible? Evidently to show a 350-row report I need to create, and separately display on the dashboard, three different reports: 1-150; 151-300; and 301-450.
This seems a strange and really awkward case, as when someone enters row 451 I’d apparently have to set a workflow that triggers me to go create, and squeeze into the dashboard, the new 451-600 report.
Am I missing something here?
-
Hi @Cleversheet
I hope you're well and safe!
You can change it in the Report Widget settings.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives