Certain Roles allow for unhiding columns

leross21

Right now, only the Admin role for a sheet can hide and unhide a column, but this causes issues for the rest of my team who are Editors. I would like at least one of the Editor roles to be able to unhide columns as needed. We don't want to make everyone an admin (for obvious reasons), but our managers will often hide columns because the sheet is just too long (not for hiding sensitive information or something). So we'd still like to hide columns as needed, but allow for a certain subset of users with Editing rights to unhide columns.

Dani_torrone

My Team's sheets have a ton of columns too, perhaps a solution for you could be to create dynamic views for certain roles that need to focus on certain fields? That is what I did for my Team.

Andrée Starå

Hi @leross21

I hope you're well and safe!

Here's a possible workaround or workarounds

• Personal reports that they can structure how they want.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!