why wont my sheets group properly in my report

I created a report to try and get all my projects tasks organized and identifiable by project.

I have the report groups by work breakdown schedule sheet, but for some reason my latest sheet will not break out in its own group. in the image below you can see the sheet that is grouping is the template sheet, but the P-0100 sheet is grouping under this header as well.

Here is the grouping info, super simple.

Not sure what I am doing wrong. all the other sheets broke out already. Just this new one is refusing.

I reloaded the page and refreshed the report numerous times. I even tried changing the sheet name of the P0100 sheet, which did not result in any changes.

Any thoughts would be welcome. Thanks again!

Find more posts tagged with

Sheets

Reports

group by

Accepted answers

S.Stone

I had a weird reporting issue before, and after I changed one cell on the source sheet, saved, and then added/removed it from the report, it worked again.

I didn't need any actual data changed, but I just picked a cell, replaced the text with X, saved, then used version history to grab my original text and save it again.

Not sure if that will resolve this for you, but thought I'd mention it as a test. :)

All comments

S.Stone

I had a weird reporting issue before, and after I changed one cell on the source sheet, saved, and then added/removed it from the report, it worked again.

I didn't need any actual data changed, but I just picked a cell, replaced the text with X, saved, then used version history to grab my original text and save it again.

Not sure if that will resolve this for you, but thought I'd mention it as a test. :)

Deonizia Egan

That worked! Thank you! :)

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.