Workaround Needed for Smartsheet Issue with Primary Columns

mariahneu · 07/26/22

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.

markh10 · 09/22/22

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 · 09/23/22

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

Sara Campbell · 09/27/22

You can drag and drop columns to reorder them. The Primary Column is no different.<\/p>","bodyRaw":"[{\"insert\":\"You can drag and drop columns to reorder them. The Primary Column is no different. \\n\"}]","format":"rich","dateInserted":"2022-09-23T17:49:45+00:00","insertUser":{"userID":52131,"name":"Lee Joramo","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Joramo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/84\/d4\/n84d4d5e3d909b0164c8e3ad8f8e5c934.jpg","dateLastActive":"2023-05-17T20:20:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344604#Comment_344604","embedType":"quote"}"> 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 · 11/16/22

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 · 03/13/23

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 · 03/13/23

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!

Sign in to submit new ideas and vote

Workaround Needed for Smartsheet Issue with Primary Columns

Idea Submitted·Last Updated07/26/22

Comments

Categories