Skip to content

Instantly share code, notes, and snippets.

@fuzzyweapon
Last active January 14, 2020 21:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fuzzyweapon/d1ebb37cb7752cedb2afda72d25038c4 to your computer and use it in GitHub Desktop.
Save fuzzyweapon/d1ebb37cb7752cedb2afda72d25038c4 to your computer and use it in GitHub Desktop.
Google Sheets Tricks

Forgetful Basics

These are things I often need to use but forget. They aren't tricky or difficult, just reminders. * denotes a recommended method.

Return an empty/blank result...
Use `IFERROR(0/0)`
  IF(TRUE(),"blah",IFERROR(0/0))

OR

Return nothing

  IF(TRUE(),"blah",)

Commonly Useful Tricks

These are more sophisticated examples of techniques that do things often desired, but are a little tricky.

Clever Hat Tricks

Arguably a bad idea, but sometimes you just need to do what you need to do.

Best Practices

Style Guide

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment