This is a simple bit of Google Sheets formula used to add a row of incremental number is row A where row B is not blank.
Add Incremental Numbers Where Other Row is Not Blank
Posted on 25/02/2025
Tag: Code
All types of code.
From Shortcode, CSS, SCSS, PHP (maybe a little JavaScript) and HTML on WordPress.
To C++ in Arduino and Java in Android.
Lock Google Docs On Shared Drives
Here’s a simple bit of Google Apps Script for locking a document (effectively making the document read-only).
Posted on 28/01/2025
Replace Links With URL In Active Google Sheet
A simple bit of Google Apps Script that converts all links within an active Google Sheet into full URL links instead.
Posted on 28/01/2025
Get Last Row in A Column Using Google Apps Script
Another simple bit of code that’s worth writing down: how to get the last row in a specific column using Google Apps Script.
Posted on 08/12/2024
Count Cells That Contain A Word In Google Sheets
A simple bit of code that’s worth writing down for counting all cells in a column that contain a specific word/symbol.
Posted on 08/12/2024
Change Colour Of All Links On Active Google Sheet
A simple Google Apps Script that I came up with to change the colour of every link within the current active sheet all at once.
Posted on 29/07/2024
Show Block After Set Date Shortcode
Announcing an event or closing a vacancy? Here’s a shortcode for your WordPress child theme that shows a block only after a predetermined date has passed.
Posted on 16/04/2024
New EU Consent Requirements for Google Analytics
A simple explanation of Google Analytics’ new EU consent rules and how to satisfy them with a simple script.
Posted on 03/04/2024
How to Check if a Cell is a Function Using Conditional Formatting
In this guide, I’ll walk you through the simple steps to set up conditional formatting to identify functions in Google Sheets.
Posted on 02/04/2024
MailChimp Popup Button
A simple script that you can use to make your MailChimp popup form button activated rather than spamming every new visitor with the popup.
Posted on 02/04/2024
