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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
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
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 141 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives