ip/addTempChangeOrderValues at master · evcobp/ip · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
/*='Change Order 10'!C6	=Validation!AN110
  Change Order 10
  ='Change Order 10'!C2
  ='Change Order 10'!J4
  ='Change Order 10'!E20
  ='Change Order 10'!J3
  ='Change Order 10'!J7
  ='Change Order 10'!J8
  ='Change Order 10'!J9
  ='Change Order 10'!J5
  ='Change Order 10'!J6*/

function tempChangeOrder() {

  var values = [
  "='Change Order 32'!C6",
  "=Validation!AN328",
  "Change Order 32",
  "='Change Order 32'!C2",
  "='Change Order 32'!J4",
  "='Change Order 32'!E20",
  "='Change Order 32'!J3",
  "='Change Order 32'!J7",
  "='Change Order 32'!J8",
  "='Change Order 32'!J9",
  "='Change Order 32'!J5",
  "='Change Order 32'!J6"
  ];
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getSheetByName('ChangeOrders');
      var first_row = sheet.getRange(['A41:L41']);
  var first_row_values = first_row.setValues([values]);

}