Skip to content

Instantly share code, notes, and snippets.

@franklinokech
Created March 13, 2019 13:40
Show Gist options
  • Save franklinokech/b43c2143f4d962f5ea38885af55bbd72 to your computer and use it in GitHub Desktop.
Save franklinokech/b43c2143f4d962f5ea38885af55bbd72 to your computer and use it in GitHub Desktop.
Google script app to run some code when A sheet gets edited
function onEdit(event) {
var sheet = event.source.getActiveSheet();
var range = event.source.getActiveRange();
// move
if (sheet.getName() == 'Problems' && range.getColumn() == 12 && range.getValue() == 'Resolved') {
var row = range.getRow();
var numColumns = sheet.getLastColumn();
var tRange = sheet.getRange(sheet.getLastRow() + 1, 1, 1, numColumns);
tRange.setValues(sheet.getRange(row, 1, 1, numColumns).getValues());
tRange.setBackgroundColor('#99ccff');
sheet.deleteRow(row);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment