google sheets API

gas.js

// count by regex
COUNTIF(range, "F1*")

// countif more/less
COUNTIF(range, ">2015-01-01")

// countif NOT
COUNTIF(range, "<>Läkare")

// url - google sheets regex syntax
var url = "https://github.com/google/re2/blob/master/doc/syntax.txt"

// reference to variable in cell that will not move on drag :)
var noMover = "$A$1"

// convert to number - date, time or string
VALUE()

// convert from number to string (num, format)
TEXT()

// filter vs sumifs and countifs
"Only use FILTER to return values (not to count as it will always return at least 1)"
"Use COUNTIF(S) or SUMIF(S) to calculate"

// return latest date
MAX()

// scripts editor
data[columnIndex][rowIndex]
// if data is single array
typeof data[0] == 'Object' // true
typeof data[0][0] == 'String' // true
data[0][0][0] // first letter of string :)
// if data is array of arrays
data[0] // row 0
data[0][0] // row 0 column 0
data[0][0][0] // row 0 column 0 correct cell type