Report column groupings showing text under the grouping name

I am attempting to create a report that groups ticket IDs by the report name. The grouping is based on the column named "Report Name Internal (Final)" and the undesired text being displayed is from the primary column.

The grouping name displays text from the primary column below the report name. What's odd is the undesired text being displayed is not within the grouping itself; the text shown is from an entirely different "Report Name Internal (Final)".

Example below shows grouping 'Sales Opportunity" shows text " -BOP Selling Inv $". This is not occurring for the grouping for "Style Sum performance". Again, no item within the 'Sales Opportunity" report group contain the text "BOP Seling Inv $"; it is from a different report.

Is there a way to get this text to go away or is this a visual glitch that cannot be resolved? Thanks!

Find more posts tagged with

Reports

Groups and Group Management

Accepted answers

Isaac A.

Hi @Capp856!

Thank you for sharing the details! Let me provide some clarity around how grouping works in reports.

When you set up grouping by a column, the groups are determined by the unique cell values in that column across all source sheets, not just by the dropdown options or predefined values in the column settings. For example:

For Text/Number columns, rows are grouped by each unique cell value (including blank cells).
For Dropdown columns, groupings include all dropdown options plus any additional values manually entered into the column on any source sheet.

Based on your description and the screenshot you provided, the undesired text seems to be caused by a value in the “Report Name Internal (Final)” column from one of your source sheets. I’d recommend checking the source sheets to identify and remove any unexpected values in that column.

Additionally, from looking at the image, this might also be a browser or latency issue. Please ensure you follow the steps in this help article to troubleshoot:
Issue: Smartsheet is continuously loading, not responding, or not displaying certain items

For more detailed guidance on grouping, check out this help article:
Group data to organize results in report builder

Let me know if this helps!

Cheers,
Isaac.

All comments

Isaac A.

Hi @Capp856!

Thank you for sharing the details! Let me provide some clarity around how grouping works in reports.

For Text/Number columns, rows are grouped by each unique cell value (including blank cells).
For Dropdown columns, groupings include all dropdown options plus any additional values manually entered into the column on any source sheet.

For more detailed guidance on grouping, check out this help article:
Group data to organize results in report builder

Let me know if this helps!

Cheers,
Isaac.

Capp856

Hi @Isaac A.

Thank you for the quick response and appreciate the detailed explanation! I was able to resolve the issue.

Thanks again! :)

kowal

Hello @Isaac A. ,

I have had exactly the same problem but I ignored it as it was not so annoying and after refresh it always disappears. However yesterday customer came to me with such issue and I opened the post here:

https://community.smartsheet.com/discussion/comment/469065#Comment_469065

as you can see customer is reading data from 254 sheets for her reports so making changes now in sheets would be time consuming so I think this cosmetic bug shall be fixed.

Also I just made a print screen of my report where I group first by Date than by Contact List than by Dropdown list before refreshing it looks like that:

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.