Month: October 2014

  • Google script: substitute blank cells by “x”

    Today I had a big spreadsheet with quite a few missing values, which I wanted to substitue by “x”. So I decided to write my first google script! I’ts pretty straight forward: in your open spreadsheet, go to Tools > Script Editor and put in the following code: function onOpen() { var sheet = SpreadsheetApp.getActiveSheet(); var…