Google Sheets Permissions – How to Set Editing Permissions Per Column

google sheetsgoogle-sheets-data-validationpermissions

I have a Google Sheet that's being edited by 3 people, but each person needs to edit only one column. EX Red will edit red column; Blue will edit blue column and Yellow, well, yellow column hahaha.

How can I make that Red can't edit Yellow and Blue; Blue can't edit Red and Yellow, and Yellow can't edit Red and Blue?

I'm trying to avoid accidental changes. I tried with the Google Sheet menu where you can block columns, but it seems there is no way to block it the way I need it.

Best Answer

click on the column of your Red comrade
select Protect range
click on Set permissions
enter the email address of your red comrade
press Done
repeat for Blue and Yellow comrade

Related Solutions

Google-sheets – Conditional Formatting based on another sheet’s content

Although you mention only A2 in sheet March I'm guessing you may want equivalent formatting throughout ColumnA, so start by selecting ColumnA then:

Format, Conditional formatting..., Custom formula is:

=match(A1,indirect("Roster"&"!D:D"),0)>0

select yellow (Range: should be A:A) and Save rules.

For each colour you need a separate rule (unless one colour is acceptable by default, so standard formatting applied for that) hence for red for example + Add another rule of:

=match(A1,indirect("Roster"&"!E:E"),0)>0

and repeat for blue (B:B in place of D:D in the first formula) and green (C:C).

How to Set Column Width Across Multiple Google Sheets

The cause of the error is that the firstSheet doesn't have the same number of columns than the currentSheet.

You could avoid this error by checking if firstSheet.getMaxColumns() >= currentSheet.getMaxColumns()

Best Answer

Related Solutions

Google-sheets – Conditional Formatting based on another sheet’s content

How to Set Column Width Across Multiple Google Sheets

Related Topic