Google Sheets doesn’t do special characters from the File Menu. Here is a script (must check if there is an Add-on for this! There is but wants an annual subscription!) that provides a few: Continue reading
A little timesaver. Google Sheets doesn’t have a “Special Characters” selector, so if you want to use one you have to open up a Google Doc, copy the character you want, then back to Sheets to use it. This example shows a simple apps script for inserting a checkmark to a cell. We will then look at conditional formatting of the cell/cells. Continue reading
This should be easy peasy, but it actually takes a fair bit of scripting to get it to work, especially if you have more than one tab on your base spreadsheet. Continue reading
I use this a lot, but not enough to remember how to do it each time!
Say you want to reference a range of cells but only the ones with values. First up you need to count the cells that have values. you do this with, for example: Continue reading
Doesn’t seem to matter which word processor you use, the label sheets never line up properly. No difference in Google Apps for this. But life can be made easier by pulling address data down from a list of rows and columns, and placing one full address in a cell, ready to go. Continue reading
Nice little equation that I can’t take credit for, can’t remember who provided it in the first place.
Say you have a list of peoples names in the format: Continue reading
Been happily grabbing data ranges from cell ranges in google sheets for ages, but never spotted that if you have a range where all the cells have data validation in them (e.g. a list of values or list from range), then even if they are blank, e.g. no selection has been made, GAS still counts them if you get the “length” of the array. This little snippet deals with that! Continue reading
A downside with GAS spreadsheets is the inability to share them and properly protect them at the same time, whilst remaining usable by an end user. So if I want an “unknown” and “untrusted” user to access the sheet and select from dropdowns etc., i must give them editing rights.
This example shows how to check and restore a cell validation each time the sheet is opened. Continue reading
Just a few tips and tricks for either creating or modifying pdfs under linux.
You will need to have ghostscript, imagemagick and pdftk installed.