Make Hiding & Unhiding columns an Automation function

Carson Penticuff

Perhaps my "search foo" is a bit rusty, but I could not find an existing suggestion for this specific issue, only several tangentially related suggestions.

I believe this is pretty self-explanatory. I have sheets with several checkbox columns that are typically hidden, but often need to be unhidden to perform some action. (usually to specify which rows will be included in different automations) Using reports is not a viable option for my use case, and manually finding and unhiding these columns can be very time consuming, as they are spread out among dozens of other columns.

The ability to create separate Hide and Unhide automations (that I would run manually) would be a great timesaver.

Randy B CDN

I too have several use cases where triggering hide/unhide with a checkbox would be very useful. It would allow me to create multi use sheets while keeping all the data in one place rather than create different versions of the same sheet then having to aggregate the data.

KGF

Came here to suggest the same thing. I have a large sheet that I need to share but some columns should not be seen by those people. I'd like to see a button that allows me to toggle between hidden and unhidden so that I can see those columns when I need to without having to go and hide them all again, one by one.

Surfer_Jet

I have another "brilliant" idea! For administrators, please create a macro to hide and unhide columns. You do not have it yet, but do the same for rows (hide and unhide) and include a macro.

Come on, I have seen other posts and it takes years. Let's go!

Courtney S.

We've been using Smartsheet sheets as attendance sheets, with checkbox columns for each day of programming. To make the attendance-taking easier, each Friday I've been editing all the attendance sheets to manually hide the completed week's date columns and unhide the upcoming week's columns, so that there's only ever one week of date columns visible. I would love to be able to automate this.