Dec 1, 20212 min3 Ways to Safeguard Your Google SheetIf you are building tools for use by an organization or online audience, you need to know how to 1) protect tabs; 2) auto-copy; and 3)...
Nov 1, 20212 min2 Tips for Using IMPORTRANGEIMPORTRANGE is what allows your Google Sheets files to talk to each other. Here are two tips to improve that talk.
Mar 1, 20212 minHow to Flatten Survey Data in Google SheetsThis sequence of steps lets you easily “flatten” a data set in Google Sheets, by organizing matrixed data into simple objects and fields
Feb 1, 20212 minWhen Structuring Your Model, Think "ETL"Use "ETL - Extract, Transform, Load" as a framework for structuring your next model or Sheets-based tool