Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function conditionalNewRow() {
- var ss = SpreadsheetApp.getActive();
- var sh = ss.getActiveSheet();
- var headerRow = 1;
- var firstRow = headerRow + 1;
- var range = sh.getRange("A2:D2");
- var futureRange = sh.getRange("A3:D3");
- var numCols = range.getNumColumns();
- var contentVal = false;
- for (i = 1; i <= numCols; i++) {
- var currentValue = range.getCell(1,i).getValue();
- if (currentValue == "NA"){
- contentVal = true;
- break;
- }
- }
- if (contentVal == true) {
- sh.insertRowBefore(firstRow);
- futureRange.copyTo(sh.getRange(firstRow, 1, firstRow, numCols), {contentsOnly:false});
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement