Row limits in Reports / Grouping

Kevin Pedersen

I am pulling data from 2 different sheets that currently span about 5,000 rows with more to come. When I create a report looking to group the information certain ways it seems that the row limit inside the Report itself is 2,500, is that correct? When the data is grouped, I cannot uncollapse the groupings unless it is inside 2500 rows. And if i do not group, the report still stops at 2500 rows.

Is anyone else seeing this? Are there plans for the size of Reports to expand beyond this limit?

Debbie Sawyer

Hi Kevin

In this help article it does concur with you that grouping is limited to 2500 rows and will automatically collapse at this threshold.

https://help.smartsheet.com/articles/2482082-configure-grouping-to-organize-results-in-report-builder

Debbie Sawyer

No worries Kevin.

I'm afraid I don't know what will come next with Reports & Grouping! As is it a new feature I am sure Smartsheet are monitoring its acceptance into the community and will be looking for enhancement requests as people use it and can see scope for improvement.

I would recommend putting an enhancement request forward if this is something you'd like to see developed!

Kind regards

Debbie

Debbie Sawyer

Hi Kevin

In this help article it does concur with you that grouping is limited to 2500 rows and will automatically collapse at this threshold.

https://help.smartsheet.com/articles/2482082-configure-grouping-to-organize-results-in-report-builder

Kevin Pedersen

Thank you Debbie! Do you know if there are any plans to go beyond the 2500 for grouping? I do see my report goes onto a 2nd page beyond the 2500 so thats atleast helpful.

Appreciate the quick response

Debbie Sawyer

No worries Kevin.

I'm afraid I don't know what will come next with Reports & Grouping! As is it a new feature I am sure Smartsheet are monitoring its acceptance into the community and will be looking for enhancement requests as people use it and can see scope for improvement.

I would recommend putting an enhancement request forward if this is something you'd like to see developed!

Kind regards

Debbie