Moment JS in Google Sheets (Apps script) – The easy/lazy way
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…
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…
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…
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…
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…
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"…
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…