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.