The SEQUENCE function is an amazingly useful function in #GoogleSheets. It lets you create sequences of numbers from a single formula. The obvious use case is to create a count up 1, 2, 3, 4, 5 etc.
But did you know you can easily create a count down in your Sheets too? π
This single, simple formula:
=SEQUENCE(100,1,100,-1)
counts down from 100 e.g. 100, 99, 98, 97, 96...1
To count down from some other number, for example 50, change it as follows:
=SEQUENCE(50,1,50,-1)
Easy-peasy!
The four numbers you enter as arguments to the SEQUENCE function represent:
β Number of rows (e.g. 100)
β Number of columns (e.g. 1)
β Start number (e.g. 100)
β Step to increase/decrease by (e.g. -1)
If you create #GoogleSheets that multiple people use, one super helpful thing you can do is add a sidebar to your Sheets, containing key info or instructions.
Today I'm going to show you how to create sidebars using the group columns feature...
STEP 1οΈβ£
Highlight some columns, right click, and choose Group columns.
This adds a button above the columns, which you can toggle to show/hide these grouped columns.
STEP 2οΈβ£
Right-click on the +/- button and select left or right to set the +/- toggle button to be on the left or right of the group.
Let's talk about building numbered lists with the amazing SEQUENCE function.
It used to be that you had to resort to obscure array formulas like =ArrayFormula(row(1:5)) to get lists of numbers. Things got ugly fast if you wanted to customize these lists.
(1/13)
With the SEQUENCE function, you specify these arguments:
1) the number of rows 2) the number of columns 3) a start value 4) a step size
(2/13)
Arguments 2, 3 and 4 are optional. However, if you want to set them you need to include the previous ones (e.g. if you want to set a step size in argument 4, then you need to set 1, 2 and 3 as well).