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.