How to allow onEdit function to affect protected cell in a Google Sheet?

by

You can use an installable trigger running on edit. Such a trigger runs as the user who created it, regardless of whose edit caused it to run. So, if you are the creator of the trigger and your account is authorized to edit protected cells, they will be updated.

More Related Contents:

  1. Google Sheets OnEdit() – You do not have permission to call a service
  2. onEdit simple trigger never seems to be triggered
  3. “SpreadsheetApp.getUi() cannot be called from this context”
  4. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  5. google script openById : You do not have permission to perform that action
  6. e.range.getA1Notation() unable to track changes caused by formula update
  7. Determining the last row in a single column
  8. Moving google apps script to v8 file upload stopped working from sidebar
  9. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  10. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  11. No permission to call msgBox in Google Apps Scripting
  12. How to define global variable in Google Apps Script
  13. Periodically refresh IMPORTXML() spreadsheet function
  14. Format a Google Sheets cell in plaintext via Apps Script
  15. UiApp has been deprecated. Please use HtmlService instead
  16. Moving Files In Google Drive Using Google Script
  17. How to get filtered values from Filter after using setColumnFilterCriteria?
  18. Protect ranges with google apps script
  19. How to access new ‘in-cell-image’ from google apps script?
  20. How to convert a Google Sheets-File to an Excel-File (XLSX)
  21. Difference between getValue() and getDisplayValue() on google app script
  22. use onedit() trigger on a specific sheet within google scripts for google sheets
  23. Measurement of execution time of built-in functions for Spreadsheet
  24. Google Spreadheets Scripts: check if cell is empty
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. .setFormula() and received error missing ) argument list
  30. Passing cell references to spreadsheet functions

Leave a Comment