The Checkbox (Tick box) Has Arrived on Sheets

After a wait of several days since being announced in the latest update the checkbox has made it to Google Sheets.  NB in the UK a checkbox is called a tick box, so in the screenshots below you will see tick box instead. So far the implementation seems to be a solid new feature.  To …

Update for Google Sheets brings Macros and Checkboxes (not fully rolled out yet)

Google announced an update for Google Sheets on 11 April.  The new features look very exciting with macros being the headline feature.  Macros enable you to record a series of edits to a Google Sheet that you will repeat and then save them in a menu to replay anytime to automate that series of actions.  …

Track the Important Numbers in Your Life : How to set up a Number Dashboard (d#board) in Google Sheets

Number dashboards (d#board) can be used to track numbers that are important to you.  They are built on Google Sheets but can be easily and quickly viewed on mobile browsers.  If you already have numbers calculated and stored in other Google Sheets you can easily copy a d#board into existing spreadsheets and plug in your numbers. …

Good Bye Numerous, you will be Missed

On 1 May a fantastic app, Numerous, will cease to function. It will be missed by its many active users. In order to lessen the blow I designed a spreadsheet that can replace some of the functionality of Numerous.

Fast HTML Table Creation and Editing with a Spreadsheet

If you are designing a table in html there is a lot of tedious repetitive typing to do. A spreadsheet can be used to take a lot of the tedium out of the process. Previoulsy I have used spreadsheets to generate repetitive text and html in what I think was a relatively efficient way. I …

Scaled Conditional Formatting Arrives in Google Sheets

Good news spreadsheet people: you can now use colour scales in the conditional formatting in Google Sheets.  So now you can get a quick visual representation of a group comparison.  As a teacher I occasionally need to rank student achievement across a whole class / cohort (the more common and important analyses are those against …