sheets
see also docs
MATCH
als een item in een lijst voorkomt dan een X en anders niks
=IF(ISNUMBER(MATCH(B2; covers!A:A; 0)); "X"; "")
FILTER
=FILTER('sheet2'!$E:$E;'sheet2'!$D:$D=C1))
toggle formula / value view
Ctrl + `
kwartaal
="K"&int(INT(mid(G16;6;2))/4)+1
make column with unique values from a matrix
=SORT(UNIQUE(FLATTEN(A2:E)))
replace
lower(REGEXREPLACE(REGEXREPLACE( REGEXREPLACE(REGEXREPLACE(Trefwoorden!C2:C; "[–’+=&?|,\.() ""$/':;]"; "-") ;"-+";"-"); "[^a-zA-Z0-9\-]";"");"^-|-$"; ""))
Vlookup with Search Key in Multiple Column Range
https://infoinspired.com/google-docs/spreadsheet/vlookup-find-a-search-key-in-multiple-columns-matrix-in-google-sheets/ (won’t work in Excel)
=ArrayFormula(split(flatten(B2:D7&"|"&A2:A7);"|"))
transpose comma separated values in multiple rows to one long list of items
=transpose(split(join(",";D:D);","))
shortcut for new sheet
Automatische links in spreadsheet kolom voor elke regel
'place this in the header cell above a column, that way you will still be able to sort the sheet
=ArrayFormula(if(A1:A<>"",hyperlink("https://....."&A1:A,"title:"&A1:A),))