Google docs

Page dedicated to Google office apps (Docs, Sheets...)

Google Sheets

• Example of range: A1:B2, Sheet3!A1:B2, B:B (one column), Sheet3!2:2 (one row on another sheet)
• Conditional formatting: cannot use data from another sheet!

Tips

Create buttons in Android

• [1], [2],
• Button doesn't work.
• Instead create cells with dropdown list (Data -> Validation -> Select from list of items), then add a onEdit event in Script:

   /**
    * Trigger to simulator button actions using a dropdown list on Android.
    */
   function onEdit(e) {
     if (e.range.getA1Notation() == 'A1') {
       if (e.value == 'Reset') {
         resetWarnings();
         e.range.setValue("(action)");
       }
       if (e.value == 'Clean') {
         cleanWarnings();
         e.range.setValue("(action)");
       }
     }
   }

Google Apps Script

• Google Apps Script Reference
• Beginner guides:

• Extending Google Sheets (Google)
• Custom functions (Google)
• Custom Menu (Google)
• BenCollins, Ben Collins, Google Sheet buttons

• Date / Number

• Date and Number Formats
• To set date in a cell (with date format): sheet.getRange(1,2).setValue(new Date());
• To set date as a string [3]: var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy")