Report not displaying rows

Can anyone assist? I have two reports with the same set up but for some reason my second sheet does not display the corresponding rows under grouping.

In the first sheet it works fine:

However in my second row, It's asking me to filter but does not show the rows even if I filter by date.

Any idea on why? This sheet has about only 1300 rows filled at the moment.

Find more posts tagged with

Accepted answers

Paul Newcome

It is because your second report is pulling in too many rows to be able to display them.

All comments

Paul Newcome

It is because your second report is pulling in too many rows to be able to display them.

Jimrny

https://community.smartsheet.com/discussion/comment/374911#Comment_374911

Got it. Didn't think it would count more than the rows that are actually filled.

Was able to get my results by filtering per year.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.