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.
Function that fixes a particular type of data structure
A guide for using tables to enhance data structure practices
Type Coercion in Google Sheets
Booleans in Google Sheets
How to use SUMIF(s)-COUNTIF(s)-AVERAGEIF(s)
How to use the Vlookup Function
Operators in Google Sheets.
Investigating how Unicode emoji sequences work in Google Sheets.
Refactoring your formulas using LAMBDA to make it more readable and usable
A library of fuzzy lookup functions for Google Sheets.
Adding comments.
This blog post is a sandbox for markdown tools.
An archival post for the old LAMBDA UDT method.
An alternative method to a cell checking against many criteria
This blog post will regularly update with information about planned and proposed features.
The MAP Function
Functional data abstraction using LAMBDA.
Functional data structure implementations using LAMBDA.
This article was written for the Spreadsheets Discord Community
The pivot table data structure is a common one, often resulting from the pivot table feature or the QUERY function.
QUERY smush is a technique that joins all elements of each column of an array together.
Query Arithmetic
LAMBDA Update Suppression
LAMBDA Recursion
Calculation Limits
The LAMBDA Function
A method of adding documentation/comments to formulas.
A set of techniques that produce non-hardcoded values.
The QUERY function performs SQL-lite queries using the Google Visualization API Query Language.
Marking the inception of this site, with some info on how it was created.
Advice on setting up data structures for Google Sheets.
Recreating the Levenshtein Distance Algorithm in Google Sheets in response to ztiaa's challenge.
Elements with no height or width can be useful in array construction.
Why formatting should not be the basis of your backend.
Ordered collections of elements.