Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. function conditionalNewRow() {
  2. var ss = SpreadsheetApp.getActive();
  3. var sh = ss.getActiveSheet();
  4. var headerRow = 1;
  5. var firstRow = headerRow + 1;
  6. var range = sh.getRange("A2:D2");
  7. var futureRange = sh.getRange("A3:D3");
  8. var numCols = range.getNumColumns();
  9. var contentVal = false;
  10.  
  11. for (i = 1; i <= numCols; i++) {
  12. var currentValue = range.getCell(1,i).getValue();
  13. if (currentValue == "NA"){
  14. contentVal = true;
  15. break;
  16. }
  17. }
  18. if (contentVal == true) {
  19. sh.insertRowBefore(firstRow);
  20. futureRange.copyTo(sh.getRange(firstRow, 1, firstRow, numCols), {contentsOnly:false});
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement