Hide/unhide colums by filter

adamhourigan

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.

Marcela

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