#semiprogrammer

Rpsu (326 ppm)rpsu@mas.to
2024-11-19

Wouldn't it be nice if one could declare variable or constants in a formula in Google Sheet? Define something once and reuse it multiple times within one formula.

= declare(VAR=(if(A="";B;A))&&right(VAR,len(VAR))

(And directly in the sheet, not via apps script.)

#googlesheet #semiprogrammer #programming

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst