Sign in to submit new ideas and vote
Get Started

Unhide specific columns on a sheet

2»

Comments

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp Community Champion

    I manage columns using an API tool (*) when working on large-scale developments. However, when I need to check hidden columns quickly, I use the following method:

    Edit Row Menu

    For example, the image below is the WBS template sheet, in which I hide columns to see necessary information in the Gannt view.

    Click on "Edit" from the row menu. The menu displays all columns, including hidden ones. Click on "fx" to view the column formulas.

    Send Update Request Row Menu
    From the row menu, click on "Send Update Request." By default, when you click "Include," only the visible columns are checked. The checked columns make it easy to see which columns are hidden and which are visible.


    I hope this helps!

    (*)

    API Tool Image

  • Adrian Mandile CHESS
    Adrian Mandile CHESS ✭✭✭✭✭

    One way that I work-around knowing which columns should be hidden, is to use Conditional Formatting – reserving the seldom used very pale purple background and automatic or dark grey font, so that when I have to re-select the columns it is more apparent.

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

  • Darren Mullen
    Darren Mullen Community Champion

    @jmyzk_cloudsmart_jp That's a cool trick I wasn't aware of. We've also just released a solution for this through my partnership with SSFeatures:

  • @jmyzk_cloudsmart_jp - Thank you for sharing this workaround!

  • Josh W
    Josh W ✭✭✭✭

    I have been asking for a popup window interface to manage columns for a long time now; a tabular view where you can sort by sheet order, sort alphabetically, change column names, set the formatting, hide & unhide, change column order etc.
    For small sheets it's no big deal, but when you have 350 columns and can't remember the exact names of every column it would have saved me Hours and Hours of hunting !!

  • sandra.love
    sandra.love ✭✭✭

    This is DESPERATELY needed!!

  • harocha
    harocha ✭✭✭✭

    100% Agree with the community members replies. Definitely, I'll follow the suggestions from Mike Jungers ; Michael TCS; and Josh W along with great comments from the participants. Thank you, gracias, obrigado, grazie…

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hey everyone, based on the feedback from this thread and other similar threads, I added these features with SSFeatures so that you can hide and unhide specific columns easier.

    • Click the checkboxes to hide and unhide specific columns.
    • Click the arrow icons to jump to that column in your sheet.
    • The filters at the top let you quickly find the column that you're looking for.
    • The "Save/Load/Delete" buttons at the bottom let you save your column settings, so that you can load them again in the future.

    If you have any other ideas, I would love to hear them. I'm constantly improving SSFeatures to make it as useful as possible.

    Thanks!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds essential features into Smartsheet.