[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over and over again, that’s a lot of wasted time. Here we’ll look at… Continue reading Pimp up your Sheet – Programmatically!
Category: Sheets
Create a Book inventory with Google Sheets & Apps Script
Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This uses a mixture of GAS code and Sheets functions. We’ve got 3 sheets: Front page – This is what the user will see and use. In… Continue reading Create a Book inventory with Google Sheets & Apps Script
Automatically emailing info from a form submission
Here we’ll look at how to set up automatic emails, which contain information submitted by the Google Form user. The beauty of this is that the information is sent to you (and others) without you having to do anything and without you having to check the spreadsheet to see if there has been a submission.… Continue reading Automatically emailing info from a form submission
Request form – Sending automatic emails
One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless uses and in this example, we have a user requesting a private class via a Google Form. The relevant parties will receive an email which will contain a short message… Continue reading Request form – Sending automatic emails
Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
Following on from my post on the basic date functions, let’s look at some really useful functions that work with dates, namely: WEEKDAY, WORKDAY, NETWORKDAYS, EDATE and EOMONTH, plus we’ll see an example with the CHOOSE function. With these we’ll: Find out the day of the week of a particular date Work out a deadline date Work… Continue reading Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
How to add alternating row colours to Google Sheets
When working with tables in a spreadsheet, we often want them to be easy to read and understand. To help us, Sheets has a quick little tool, which allows us to add alternating colours to the rows of our data, making them not just prettier but much easier to read, whilst being really quick to… Continue reading How to add alternating row colours to Google Sheets
Google Sheets – How to use Sparklines (mini-graphs)
We generally use data to give us information on something and to help us make more informed decisions. However, human beings aren’t very good at looking at a set of numbers and working out whether there is a trend or whether something looks unusual. This is where charts are invaluable. The old adage of a… Continue reading Google Sheets – How to use Sparklines (mini-graphs)
Google Sheets – What’s the difference between notes & comments?
In this post, we’re going to look at two key ways you can add extra information to your sheet, without affecting the format of your sheet: Notes and Comments. Sometimes people confuse these, as they both give extra information in the cells, but there is a clear difference between the two. The key difference is:… Continue reading Google Sheets – What’s the difference between notes & comments?
Google Sheets – Conditional Formatting & custom formulas
Sometimes we spend time colouring in our sheets so that the data is more visible, in a way that it can be read and understood really quickly and that the most important points can be ascertained with ease. Wouldn’t it be great if Sheets could colour your data automatically, depending on a set of conditions? Well,… Continue reading Google Sheets – Conditional Formatting & custom formulas
Google Sheets – Filtering your data
Let’s look at how you can filter your data to show a particular aspect of it. There are two ways to do this: Filter (by value & by condition) Filter View Filter – By value If we have a set of data, we can add some filters to enable us find the information we want. In… Continue reading Google Sheets – Filtering your data