Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
menu_book Course Curriculum (Google Sheets) expand_more
Core Formulas
SUM AVERAGE MIN and MAX COUNT and COUNTA IF IFS AND and OR IFERROR
Lookup & Reference
VLOOKUP HLOOKUP INDEX and MATCH XLOOKUP FILTER SORT UNIQUE INDIRECT
Text & Dates
CONCATENATE / & TEXTJOIN LEFT RIGHT MID SPLIT REGEXEXTRACT DATE TODAY and NOW DATEDIF
Array & Query
ARRAYFORMULA QUERY select QUERY where QUERY group by SUMIF / SUMIFS COUNTIF / COUNTIFS AVERAGEIF SEQUENCE
Data Quality & Analysis
data validation dropdown conditional formatting formula remove duplicates named ranges pivot table concept SPARKLINE percent formatting absolute references
Collaboration & Automation
protected ranges filter views comments and notes IMPORTRANGE GOOGLEFINANCE Apps Script custom function Apps Script onEdit trigger publish/share permissions
Google Sheets / Collaboration & Automation

Apps Script onEdit trigger

Learn Apps Script onEdit trigger in Google Sheets with a dedicated explanation, a concept-specific example, practical cautions, and a mastery check.

12 min read • Advanced
google-sheets-047.txt
text 
function onEdit(e) {
  const sheet = e.range.getSheet();
  if (sheet.getName() === 'Tasks' && e.range.getColumn() === 3) {
    e.range.offset(0, 1).setValue(new Date());
  }
}
What to watch
Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

Apps Script onEdit trigger Mastery Check →
← PREVIOUS
Apps Script custom function
NEXT →
publish/share permissions