Im trying to protect a sheet, but the problem is that if i protect all the sheet, it doesnt permit to add information to the users, so this is my question, Is it possible to let them add new information, but not to edit the past infromation?
function protect(){
var hoja = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Respuestas_N.F");
var range = hoja.getLastRow();
var protection = hoja.protect();
protection.setUnprotectedRanges([range])
.setDescription("")
.removeEditors([""]);
}
I was trying with this script but it doesnt has the correct format, is there anyway to make this possible?