Google have recently added two useful new functions to Google Sheets, CHOOSECOLS and CHOOSEROWS, which allow us to easily show certain rows or columns we want from a data range. Let’s see how they work with a couple of examples. choosecols Here, we have some questionnaire feedback on a group of teachers and the academy… Continue reading How to use CHOOSECOLS and CHOOSEROWS
Author: bazroberts
How to set up data validation in Google Sheets
In this post, we’re going to look at how to set up data validation in Google Sheets as a whole and how it can be used to validate different types of data being entered and make it easier for the user to enter the data. This expands on my post, where I looked at creating… Continue reading How to set up data validation in Google Sheets
How to combine arrays of data into 1 sheet
In this post, we’re going to look at how we can easily combine arrays of data on separate sheets in a Google Sheet and add them on one single sheet. We’re going to use the relatively new spread operator (…) to do this. Situation In this example, we have a set of data on 3… Continue reading How to combine arrays of data into 1 sheet
How to easily add drop-down menus in Google Sheets
Drop-down menus in Google Sheets allow the user to select specific options in a cell which controls what they input into the cells. It also makes it easier and quicker to input the data. When you click on the cell, you will be presented with lovely looking options to click on. Previously, to add a… Continue reading How to easily add drop-down menus in Google Sheets
How to easily create a timeline in Google Sheets
In this post, we’re going to look at how to create a timeline in Google Sheets, which automatically creates a timeline from a set of data. Action plan A common use of this is to visually see the actions in a project action plan across a period of time. Below is a simple action plan… Continue reading How to easily create a timeline in Google Sheets
Learn how to make a World Cup game using Apps Script
It’s almost World Cup time and I thought what better way to get into it than to create a little World Cup game amongst friends and colleagues using Google Sheets, Sites, and Apps Script. This year I decided to create a game where the participants guess how many goals will be scored in each stage… Continue reading Learn how to make a World Cup game using Apps Script
Learn useful Google URL tricks to make your online easier
In this post, we’re going to look at several useful Google URL tricks which allow us to quickly do a whole range of things, like quickly create documents, provide links to copy master templates, and from a link automatically download a PDF version of a document, and many more. We’re going to look at….. Useful… Continue reading Learn useful Google URL tricks to make your online easier
How to split Google Slides automatically
In this post, we’re going to see how to split Google Slides automatically into separate files with Apps Script. Problem and solution The reason I wrote this script was to resolve a problem at work, where we have an admin system that produces a document with the certificates for the students that are going to… Continue reading How to split Google Slides automatically
How to make an automatic team maker app using Apps Script
In this post, we’re going to look at a script to be able to make an automatic team maker which makes even teams from a selection of players. I play football every Sunday and every week my friends sign up to play and most weeks there are different players playing, so we end up having… Continue reading How to make an automatic team maker app using Apps Script
JavaScript – Template Literals
In this post, we’re going to look at template literals. What can you do with them? Uses of template literals Mixing single and double quotes First of all, these live in between back-ticks (`) instead of single or double quotes. e.g. This then means we don’t have to worry about what type of quotes we’re… Continue reading JavaScript – Template Literals