Pack-Unpack
Method for compressing data for exporting
All Pages
Getting the last checkbox that was clicked (Timestamp method)
It's imposible to know which ckeckbox or dropdown was last edited visually using their current state. In this article, I will present a method using timestamps in order to determine which event occured last.
STRUCTFIX
Function that fixes a particular type of data structure
Tables
A guide for using tables to enhance data structure practices
Type Coercion
Type Coercion in Google Sheets
Booleans
Booleans in Google Sheets
SUMIF(s)-COUNTIF(s)-AVERAGEIF(s)
How to use SUMIF(s)-COUNTIF(s)-AVERAGEIF(s)
VLOOKUP
How to use the Vlookup Function
Operators
Operators in Google Sheets.
Emoji Modifiers in Google Sheets
Investigating how Unicode emoji sequences work in Google Sheets.
LAMBDA Refactoring
Refactoring your formulas using LAMBDA to make it more readable and usable
FLOOKUP
A library of fuzzy lookup functions for Google Sheets.
Adding comments to sheets.wiki
Adding comments.
Markdown Sandbox
This blog post is a sandbox for markdown tools.
Method-Based LAMBDA UDTs
An archival post for the old LAMBDA UDT method.
An alternative approach to using AND()/OR()
An alternative method to a cell checking against many criteria
Roadmap
This blog post will regularly update with information about planned and proposed features.
The MAP Function
The MAP Function
LAMBDA User-Defined Types
Functional data abstraction using LAMBDA.
LAMBDA Data Structures
Functional data structure implementations using LAMBDA.
Asking Questions
This article was written for the Spreadsheets Discord Community
Unpivotting
The pivot table data structure is a common one, often resulting from the pivot table feature or the QUERY function.
Query Smush
QUERY smush is a technique that joins all elements of each column of an array together.
Query Arithmetic
Query Arithmetic
LAMBDA Update Suppression
LAMBDA Update Suppression
LAMBDA Recursion
LAMBDA Recursion
Calculation Limits
Calculation Limits
The LAMBDA Function
The LAMBDA Function
Documenting Formulas
A method of adding documentation/comments to formulas.
Unstable
A set of techniques that produce non-hardcoded values.
The QUERY Function
The QUERY function performs SQL-lite queries using the Google Visualization API Query Language.
Creating sheets.wiki
Marking the inception of this site, with some info on how it was created.
Taming Spreadsheet Data: Structure for Success
Advice on setting up data structures for Google Sheets.
Levenshtein Distance
Recreating the Levenshtein Distance Algorithm in Google Sheets in response to ztiaa's challenge.
Zero Elements
Elements with no height or width can be useful in array construction.
Color (and other formatting) Should Follow Data, Not Transmit It
Why formatting should not be the basis of your backend.
Arrays
Ordered collections of elements.