Sign in to submit new ideas and vote
Get Started

Column widths should be lockable

CarlaB
CarlaB ✭✭✭✭

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.

33
33 votes

On Radar · Last Updated

Being able to either lock column widths on a sheet or make adjusting them a per-user setting is a good idea. While this is not part of our current plan, we appreciate the feedback. Please keep commenting on this and other ideation posts that interest you!

«1

Comments

  • paulen
    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
    CarlaB ✭✭✭✭

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


    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?

  • 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
    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)

    Julie Becker ☠️

    Construction Project Engineer / Coordinator & Software Program Oversight Mgr. 😉

    Successful People Are Not Gifted; They Just Work Hard, Then Succeed On Purpose‼️

  • Adrian Mandile CHESS
    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.

    Adrian Mandile
    CHESS Consulting Australia - Smartsheet Solution Provider Gold Partner
    Collaborative | Holistic | Effective | Systems | Solutions

  • Harry Luk
    Harry Luk ✭✭✭

    bump - this is important

  • 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.

  • 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
    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.

  • Will.Parente
    Will.Parente ✭✭✭✭✭

    This would be great! Please make it happen!

  • Harry Luk
    Harry Luk ✭✭✭

    it's "on radar" - YEAH!