I have a problem with google sheet. The situation goes as follow:

Columns A B C D

A: ID, Every one have access to the column and can edit.

B: Only team 1 have access and can edit.

C & D: Only team 2 have access and can edit.

I espected that:

team 1 can filter and change column A and B.

team 2 can filter and change column A, C and D.

At the moment they can edit their respective columns, but no one can use any filter on any column.... probably because they are "changing" (filtering) some columns that are protected.

Is there some way I can solve this issue? I need all of them to work on the same sheet.

  • Have you already tried to use filter views? – Rubén Aug 3 '19 at 1:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.