Spreadsheets
(GSheets) Formula cheatsheet, including some trivial (?) stuff for completeness sake.
Search isn’t implemented yet, so just Ctrl-F
.
(GSheets) Formula cheatsheet, including some trivial (?) stuff for completeness sake.
Search isn’t implemented yet, so just Ctrl-F
.
=IF(C2="", 0, COUNTA(SPLIT(REGEXREPLACE(C2, "\s+", "|"), "|")))
=LEN(C2)
=ArrayFormula(if(C3:C<>"",row(A3:A)-2,""))