Multiple Grid view for Grid sheet
I am trying to create multiple grid view for multiple users.
For example I work in an organization with two departments, department one needs to access the grid sheet and update col1, col2, col3 ( and only view these columns )
For department two, they need to access the grid sheet and update col4,col5,col6 ( and only view these columns )
the owner of the sheet will be able to view all the columns.
is that possible? and if there is a way around this, how can we achieve it?