Moment JS in Google Sheets (Apps script) – The easy/lazy way
dsottimano Date/time handling in JavaScript is a bit of a pain, thankfully there are libraries like Moment JS to save the day. If you want to integrate better time/date handling from…
Google Docs Formula Test – Can you finish this quiz?
I was training a friend on Google docs and decided to make a little quiz out of it. Most of the formulas translate into Excel as well, but some are…
How to check if value is in range of cells – Solution – Google Sheets
One of the most useful formulas for me was being able to find if a cell contained a value from a list of items, this excellent Excel formula https://exceljet.net/formula/cell-contains-one-of-many-things was exactly…
Google Language & Country code reference sheet
This post is in addition to my previous post on Distilled and simply provides an online Google Docs version of Google CCTLDs and language codes used by Google. If you…
Count characters in a cell without spaces – Excel & Google docs
By using =Len() you're going to return the character count including spaces by default. Example: =len("hey there") This formula will return 9, this is because there's a space between "hey"…
Bulk ImportXml tool & source (Google docs spreadsheets)
There's been a few of you requesting a way to bypass the 50 importxml limit in Google docs so I've decided to release something publicly. Click here to view the…