1 // @OnlyCurrentDoc
 2 
 3 
 4 function increaseViewed(cell){
 5   SpreadsheetApp.getActiveSheet().getRange(cell).setValue(findCell(cell)+1);
 6 }
 7 
 8 function findCell(cell){
 9   var value = SpreadsheetApp.getActiveSheet().getRange(cell).getValue();
10   return value;
11 }
12 
13 function getColumn() {
14   var range = SpreadsheetApp.getActive().getRangeByName("Form Responses");
15   var values = range.getValues();
16   values.forEach(function(col) {
17     Logger.log(col);
18   });
19 }
20 
21 function formatTime(cell){
22   if(cell!=0){
23     var cellString=cell.toString();
24     var value=cellString.substring(8,10)+"/"+monthConv(cellString.substring(4,7))+"/"+cellString.substring(11,(cellString.length)-29);
25   }
26   return value;
27 }
28 
29 function monthConv(monthWord){
30   var month=monthWord.substring(0, 3);
31   if(month=="Jan"){
32     return "01";
33   }else if(month=="Feb"){
34     return "02";
35   }else if(month=="Mar"){
36     return "03";
37   }else if(month=="Apr"){
38     return "04";
39   }else if(month=="May"){
40     return "05";
41   }else if(month=="Jun"){
42     return "06";
43   }else if(month=="Jul"){
44     return "07";
45   }else if(month=="Aug"){
46     return "08";
47   }else if(month=="Sep"){
48     return "09";
49   }else if(month=="Oct"){
50     return "10";
51   }else if(month=="Nov"){
52     return "11";
53   }else if(month=="Dec"){
54     return "12";
55   }
56 }
57 
58 function firstThree(word){
59   return word.substring(0, 3);
60 }