Spreadsheets

(GSheets) Formula cheatsheet, including some trivial (?) stuff for completeness sake.

Search isn’t implemented yet, so just Ctrl-F.

desc Words Used
code
=IF(C2="", 0, COUNTA(SPLIT(REGEXREPLACE(C2, "\s+", "|"), "|")))
desc Chars Used
code
=LEN(C2)
desc Auto Index Entries
code
=ArrayFormula(if(C3:C<>"",row(A3:A)-2,""))