Recursion in Google Sheets is now possible with the introduction of Named functions, LAMBDA functions, and LET functions. In this post, we’ll explore the concept of recursion and look at how to implement recursion in Google Sheets.
Tag: Conditional Formatting
How To Alternate Colors In Google Sheets
In this post, you’ll learn how to alternate colors in Google Sheets and add row or column banding to your data tables.
Here’s an example of alternating row bands applied to a checklist in Google Sheets:
How To Create A Heat Map In Google Sheets
Heat maps in Google Sheets are a great way to add context to your data.
They bring attention to the high and low values in your data, to outliers that demand attention.
Best of all, heat maps in Google Sheets are easy to create.
Consider this dataset showing monthly temperatures for Washington D.C.:
Without any formatting, it’s boring to look at, doesn’t convey any immediate takeaways, and it’s hard to spot trends such as which years were hotter than others.
Now compare that to the same dataset with a heat map overlay (click to enlarge):
Wow! The stories jump off the page at you now. You can easily compare the years and see which years had longer winters, or hotter summers.
Let’s see how to create a heat map in Google Sheets.
How To Draw The Sierpiński Triangle In Google Sheets
The Sierpiński triangle is a fractal set in the shape of an equilateral triangle, divided into smaller triangles infinitely.
Graphically, we can draw an approximation of the Sierpiński triangle in Google Sheets:
🔗 Get this example and others in the template at the bottom of this article.
It is named after the Polish mathematician Wacław Sierpiński and is also known as the Sierpiński gasket or Sierpiński sieve.
It has the property of being self-similar, meaning it looks the same at any magnification.
See Wikipedia for more on the Sierpiński triangle.
Continue reading How To Draw The Sierpiński Triangle In Google Sheets
How To Create A Select All Checkbox in Google Sheets
In this post, you’ll learn how to create a Select All checkbox in Google Sheets, as shown in this image:
But before we look at that, did you know there’s already a quick way of selecting all checkboxes manually?
Continue reading How To Create A Select All Checkbox in Google Sheets