Sign in to submit new ideas and vote
Get Started

Hide/unhide colums by filter


It would be ideal to have the ability to setup multiple views when working with several organizations /departments. We have a sheet that has 5 different organizations that will need to edit a task list and gant chart and would love the ability to have each org only be able to see their column and not all of the columns.

6 votes

Idea Submitted · Last Updated


  • Marcela
    Marcela Employee

    Hello @adamhourigan,

    Have you thought about creating two Reports from the same sheet? That way you can provide a filtered view with select column for each team/departments to work in. You can make changes to most cell data in a Report which then immediately is updated in the underlying sheet.

    They would still need to be shared to the underlying sheet, but it would prevent the scrolling/hiding and unhiding that you're mentioning. 🙂

    Join us at Smartsheet ENGAGE 2024🎉

    October 8 - 10, Seattle, WA |Register now