Primary Columns in Grouped Reports: change label locations and move column

A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows to another sheet and perhaps change the primary column in the copied sheet to a column that you want to view in the report then you will also need to make sure that the sheets’ data is synchronized. You will need to manage at least two copies of the same data.

Sign in to vote!

Find more posts tagged with

API and Developers

Support

functionality

On Wishlist

Update Requests

Comments

markh10

I downloaded a set of templates from the Solution Center for IT Request Management. It has the 3rd column, "Issue Description" as the Primary Column. The first column "Issue Key" is Column Type "# Auto number."

How can I do the same? I thought I had to always have the Primary Column as the 1st column?

Lee Joramo

You can drag and drop columns to reorder them. The Primary Column is no different.

Sara Campbell

https://community.smartsheet.com/discussion/comment/344604#Comment_344604

only if you don't group the report - if you use grouping primary column won't move.

Constantin Hapau

The ability to move columns to the left-hand side of the primary column in a report when grouping or summaries are active.
The font colour of a text label in the Gantt timeline to be automatically set to the same font colour as that used in the row in the grid, or the ability to manually change the font colour of the text label.
The ability to expand hierarchy to a specific level rather than expanding all levels.

Chelsea.McCulley

Being able to hide the primary column while still displaying groupings would be extremely helpful when reporting on sheets with different primaries. It's sometimes not possible to rearrange sheets to have the same primary column, especially if one is a project plan and has to be the task name but the other sheet is not.

Frank Rego

Tying the Grouping Label to the primary column is restrictive. I have a large sheet that I can't reconfigure at this point, and I don't want the primary column displayed on a particular report where I still want to do grouping. Hoping that his can be fixed soon. Thanks!

mbishop

I agree that tying the group labeling to primary column is restrictive. Because of the primary column restrictions, I very rarely use the primary column as the first one. Right now I have to create and display separate reports for each group on my dashboards just to make sure the columns are in the ordered in the way I want it. Displaying a single report on a dashboard that is appropriately grouped would save me an immense amount of time and reduce complexity.

nickwhite

When grouping data on a report, the primary column becomes locked in the first column position. This becomes a problem when trying to utilize the "Use first column as series labels" option on the Chart Widget in Dashboards.

I want to group data by week in my report, and have the week appear as the labels on the x-axis of my Chart - however, this is impossible with the data grouped because the primary column is locked in the first position.

Any suggested workarounds on this would be welcome.

Thanks!

DLove

I would like the ability to display the Grouped By text above a column other than the Primary Column. I usually hide the Primary column in reports.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.