Column widths should be lockable

I'd really like to have the ability to lock a column width and/or have the column remember each person's/device's last width setting.

See: https://community.smartsheet.com/discussion/87852/lock-column-width

I work with several sheets multiple times a day that I share with a co-editor. Because of differing screen sizes and browser window shapes, we are constantly resizing columns either automatically or on purpose in ways that don't work for the other person.

[Constantly. Multiple times a day. For the past year.]

There really needs to be a way that we can either LOCK the width of a couple key columns, or the sheet should REMEMBER the way I've sized the columns and the way my coworker sized the columns and display the preferred way for each of us.

Sign in to vote!

Find more posts tagged with

Sheets

Sharing and Collaboration

On Radar

Update Requests

Comments

CarlaB

Add me as a +1 for this:

https://community.smartsheet.com/discussion/87852/lock-column-width

It's an ongoing peeve that other users can tweak the column width so that I have to readjust it every other day (if not multiple times a day).

Ty Anderson

I would be nice to allow only admins and owners to lock the column width of desired columns. Right now, any editor can resize a column or shrink the size of frozen columns, which messes up everyone else's reports and requires edits almost every time a user opens a sheet. Maybe have an option for reports to be different settings so individual users can modify column widths on reports but this wouldn't affect the master sheet.

paulen

There was a way to lock the column width of a sheet? I'd like to prevent everyone from adjusting the column widths.

CarlaB

I'd really really really really like this to happen soon:

https://community.smartsheet.com/discussion/87852/lock-column-width

I just went into a sheet, resized the primary column so that it was a few inches wide so I could read more than 2 words, and literally TWO SECONDS later, watched it resize itself to about 1" wide. I've even locked the column and demoted everyone else to 'editor' level and STILL dealing with the stupid resizing issue.

Is this on a bug list somewhere? Any hope that this major annoyance will stop plaguing my productivity soon?

BAZ1

Administrators and owners ought to be able to set and lock column widths in shared sheets......

TracyTorres

I have been using Smartsheet for years, and across 3 different companies. I don't recall this ever being an issue until I started using the Desktop App. Now it is really frustrating having to resize my primary column width over and over during the day. Please allow me to lock the width of this primary column.

Thanks

Julie Becker

I am so glad i am not the only one who deals with such nonsense hourly / daily here. I got so annoyed with a few higher level reports being changed minutes before they are exported as PDF's via email distribution that i removed everyone's access from those few reports and only gave them a published view access. This prevents anyone from going into the reports and altering the layouts, but i shouldn't have to go this extreme by literally hiding some of these reports because people won't listen or respect the sheets layouts. I've had to create duplicate sheets / reports (hide them from all access), lock columns/rows and directly link to the main sheets using formulas so that i can avoid some of this and many other issues i have.

Hopefully someone will listen to us and implement this much needed request, or else i (and maybe others) will be forced to be the bad guy and just start hiding/locking sheets to keep their format/layout intact (such childish behavior we have to do when people act like children, lol)

Adrian Mandile CHESS

We should be able to set the specific width of columns for sheets and reports and decide as Admins whether they are locked. This is especially an issue when trying to size report columns to fit in a Dashboard (that needs to be printed to PDF) when anyone can change the report column sizes as they please. In sheets the freeze column setting gets messed up when people change column widths to suit their own screen size.

Harry Luk

bump - this is important

Andreas Nissén

It would be super helpful to be able to lock a default view and let people change their own view, but have the document return to default on next open.

Karen Fairchild

I'm glad to know that I'm not crazy and the only one having this issue. It pains me to have this much technology and have to work so manually.

LucasJ

Coming here to upvote the idea. Will have several dozens of people working on sheets and reports and would like to lock the column width, so that users are not impacted by others resizing columns.

Harry Luk

yes please!

Will.Parente

This would be great! Please make it happen!

Harry Luk

it's "on radar" - YEAH!

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…
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
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…