If you've created a static site using the wonderful Hugo package and need to create some simple redirect HTML web pages then you'll need to do the following: Create your HTML template and place it in your main layout folder.Create an archetype … [Read more...] about Hugo: Redirect 301 Layout
Blog
How to Create a Google App Script Library
In our previous post on clasp and Google App Script code we discovered how we can pull code down locally, do our edits and then push it back to Google Apps. This is great when we're working on code on the back-end of Google Sheets, or Google … [Read more...] about How to Create a Google App Script Library
Flip ARRAY_CONSTRAIN Formula in Google Sheets (Example)
Previously I posted how you can use the INDEX() function to obtain the fields needed for a simple SUM() function. Then I came across another handy Google Sheet function ARRAY_CONSTRAIN(). What ARRAY_CONSTRAIN Does There are three parameters … [Read more...] about Flip ARRAY_CONSTRAIN Formula in Google Sheets (Example)
Ignore Blank Cells in QUERY Function Google Sheets
The QUERY function in Google Sheets is a powerful function that helps to operate on a range of data, however, on a current project I needed the QUERY function to ignore rows where a certain column was empty. Here was how I was able to get the desired … [Read more...] about Ignore Blank Cells in QUERY Function Google Sheets
Merge Two Columns Using QUERY: Google Sheets (Step By Step Example)
If you have two or more columns of data and you want to merge these columns into one column then using the Google Sheets QUERY formula may be one way you can achieve this. Here's an in depth explanation of how to achieve this: Step 1 - Prep … [Read more...] about Merge Two Columns Using QUERY: Google Sheets (Step By Step Example)
Google Sheets QUERY: Merge Multiple Columns & Expand Into New Structure (Example)
How do you merge multiple columns and then expand them into a different arrangement using Google Sheets? Using a working example I will demonstrate how to migrate a specific data set containing columns, into a different data set using a different … [Read more...] about Google Sheets QUERY: Merge Multiple Columns & Expand Into New Structure (Example)