When working with spreadsheets we want to be able to enter data as quick as possible and to make it as easy as possible. Here, we’re going to delve into two practical methods for seamlessly integrating calendars into your spreadsheet cells. By utilising smart chips or data validation, I’ll show you how to speed up… Continue reading How to add a calendar in a cell – Sheets
Category: Sheets
Summary of Google Workspace 2023 new features (Pt 1)
In a bustling year of developments, the Google Workspace team introduced numerous new features and improvements across their suite of apps. Here’s a concise summary of my top picks that affected Sheets, Docs, Drive, and the new AI Bard. Sheets New functions Another 11 brand-new functions were added to Sheets, including LET, TOROW, TOCOL, WRAPROWS,… Continue reading Summary of Google Workspace 2023 new features (Pt 1)
How to use Mail Merge in Gmail to email multiple people
In today’s digital era, efficient communication is vital for success, whether you’re a professional, marketer, or simplifying email outreach. Picture effortlessly sending personalized emails to many recipients, transforming each message into a custom experience. No need to imagine— in this post you’ll learn how to use mail merge in Gmail and Google Sheets, a game-changer… Continue reading How to use Mail Merge in Gmail to email multiple people
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 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. Short on time? Here’s a quick video to show you how to do it: Action plan A common use of this is to visually see the actions in a… Continue reading How to easily create a timeline in Google Sheets
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
Automatically format rows for Google Form responses
Here, we’re going to see how we can automatically format rows on a Google Sheet when a Google Form response is submitted. When the form responses come in normally, they have the default format below. But I want them to be formatted as below. So, changing the cell backgrounds to red, only showing the day… Continue reading Automatically format rows for Google Form responses
Quickly format multiple Google Sheets with Apps Script
In this post, we’re going to see how we can very quickly format multiple Google Sheets with a little help from Apps Script. The idea of this post, came from the Department of Education in Hawaii, where they have about 300 schools and a guy who works there told me he had to format about… Continue reading Quickly format multiple Google Sheets with Apps Script
How to automate Google Sheets tasks with Macros
Do you get fed up with doing the same monotonous tasks over and over again on your spreadsheets? Well, there’s one thing that may save you time – Macros. These record you doing actions on your sheets, then with a click of a button you can repeat those actions in seconds. Here, we’re going to… Continue reading How to automate Google Sheets tasks with Macros
Card sorting game using Google Sheets & Apps Script
One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both. This is the web app we’re going to make: The code There are two parts to the code, stored… Continue reading Card sorting game using Google Sheets & Apps Script