How many rows can a report collect?

Megan Yaussi

I created a report that pulls data from 4 different sheets. It has multiple items on a single date, so calendar view is the only view I am interested in using. The data on the sheets goes up to May, but in the report, it stops showing at April 15. When I look at the report in Grid mode, it is exactly 500 rows. How can I get the remainder of my data to appear or do the reports really have a 500 row limit?

Andrée Starå

Hi Megan,

The report will show 500 rows per page, but you should have an option to go to next page in the end of the report.

Do you have that?

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!

Andrée Starå

Hi Megan,

The report will show 500 rows per page, but you should have an option to go to next page in the end of the report.

Do you have that?

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!

Megan Yaussi

I see now where the next page is and I was able to see the next 500 rows of data. Ocasionally I will need to print the calendar, but since it cuts off right in the middle of the month, is there a way to have more than 500 rows per "page"? What other options are available to fix that? Multiple people will need to use this report too.

Andrée Starå

When you print you can select the range so you can print everything you need.

Would that work?

Megan Yaussi

That does help a lot. In the meantime (mostly because we're all working from home), is there a way to view a specific range as well? Some of the people who will need to view this document are not quite a savvy as others. It would be helpful to be able to see it all at once instead of having to click on to the next page. If not, we can make do.

Andrée Starå

Excellent!

Because the calendar will show everything, even empty dates there isn't a way to show it differently.

The premium add-on might be something to explore. Is that an option for you?

https://help.smartsheet.com/articles/2476776-keep-teams-organized-smartsheet-calendar-app

✅Remember! Did my post 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!