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?
Hi @Rachel Apostol
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:
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).
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.
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.
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.
@Genevieve P. Thank you. My next question was going to be about grouping but I got tied up with work.
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello, I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error. =COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row)…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.