Arrow
Beginner

Refreshing the spreadsheet basics

Get a refresher on spreadsheets.

IntroAnchor Icon

OK, maybe you’ve never touched a spreadsheet in your life, or you’ve been too afraid to ask what some terms mean - well then, let’s make things a bit clearer for you.

Tip IconThese are the absolute basics

If you already know your way around spreadsheets, you can skip this lesson and go on to Using integrations.

In this article, we'll give you a little refresher, explaining:

  • Basic terms (which you really should know)
  • Using functions

Basic termsAnchor Icon

Right, before we go anywhere, let’s cover some terms that spreadsheeters (and Rowsers) use a lot.

Spreadsheet, table, and pageAnchor Icon

In Rows, whenever you want to create something, you’ll either create a:

  • Spreadsheet
    Basically, this is a “book” that contains all your tables and pages.

  • Table
    This is a single “sheet” where you can enter your data.

  • Page
    When you have two or more tables you want to see on the same screen, you put them into a page.

kb-spreadsheet-newUI

Note IconMaximum number of tables on a page

You can only have up to five tables on a page.

Rows and columnsAnchor Icon

A row is a horizontal set of cells. They’re represented by a number.

kb-row-newUI

A column is a vertical set of cells. They’re represented by a letter.

kb-column-newUI

Cells and rangesAnchor Icon

A cell is a single “box” in your table (or as our CEO says, it’s the smallest unit of life). For example, A1.

kb-cell-newUI

A range is two or more cells put together. For example, A1:A5.

Tip IconOne-dimensional and two-dimensional ranges

Ranges can be either one-dimensional or two-dimensional. What does that mean?

A one-dimensional range only has cells from the same row or column. For example: A1:G1 (same row) or A1:A20 (same column).

A two-dimensional range has cells from multiple rows or columns. For example: A1:B5 or A1:E2.

kb-range-types-newUI

Numbers, dates, strings, and booleansAnchor Icon

The main data types that you’ll probably be using are:

  • Numbers
    Numbers can either be “whole” (that is, they don’t have a decimal - known as an integer) or decimals (also sometimes called a float). This also includes currencies.

  • Dates and times
    In spreadsheets, dates are formatted as YYYY-MM-DD (for example, 2020-07-13), while time is formatted in 24-hour format as HH:MM:SS (for example, 2:30 pm would be written as 14:30:00).

  • Strings
    Strings are basically text - Anything that’s a word or a sentence is… a string! For example: Hey there, I’m a string!

  • Booleans
    Booleans can be either TRUE or FALSE and they’re used in something called logical expressions.

Function vs formulaAnchor Icon

A function is a little “program” that already exists in the spreadsheet software. For example, SUM() which is a little program that sums numbers together.

A formula is whatever combination of functions you create to get the result you want. For example: SUM(5,7)/50.

Note IconReturns

A term that you’re going to hear a lot when it comes to functions is that the function returns something. Simply put, this means that when you use this function, it’s going to give you some kind of result. When this happens, we say that the function returns the result.

Using a functionAnchor Icon

Functions need data to work - just like in maths: you need numbers to add together in order for there to be a result, right?

The data that you enter depends on the parameter a function requires. Let's have a look at the SUM() function:

kb-function-sum

Here, we can see it requires at least two numbers (parameters) to work.

Each parameter that you enter needs to be separated with a comma ,. Why? Well, we need to tell it somehow that some data belongs to one parameter, and other data belongs to another parameter. And at Rows, we decided to use a comma 😉.

So, if we want to use SUM() to sum together 4 and 5:

kb-function-sum-one

Then if we want to sum more numbers, we just keep adding commas and numbers:

kb-function-sum-two

Functions and data typesAnchor Icon

Now, depending on the data type you need to enter into a parameter, you need to format it differently.

If it’s a…Then enter…For example:
numberjust the number5 or 50.1
number rangethe starting number, then a colon, and then the ending number10:50
number with an operatorthe number and operator within quotation marks">50"
wordthe word surrounded by quotation marks"Rows rocks"
datethe date in quotation marks"2020-02-02"
date rangewrite the starting date, then a semicolon, and then the ending date surrounded by quotation marks and square brackets."[2015;2017]"
celljust the cell referenceA4
cell rangewrite the starting cell, then a colon, and then the end cell of the range.A1:A20

Cell referencesAnchor Icon

Instead of always typing in the parameters, you can just put in the cell that contains the values. This way, you don't have to worry about whether or not they need quoatation marks or anything like that.

For example, say you have 4 in cell A1 and 5 in cell B1, then you can just write in A1 and A2 in the formula:

kb-cellreferences-newUI

Why? Well, it makes it easier to change the parameter values (you just change them in the cell). You can even reference a cell that already has a formula. And cell references are used a lot - so you should start using them!

Auto-complete and the Function HelperAnchor Icon

To make things easier for you, and so that you don’t always need to remember what parameters a function needs, Rows has a pretty awesome auto-complete.

What does it do? Well, as soon as you type in the function that you want, the auto-complete will guide you on what parameters to put in.

For example, if you type in =SUM and then click on SUM in auto-complete, you’ll see the auto-complete. And as you go through entering the parameters, the auto-complete will highlight where you are in the function:

kb-autocomplete-newUI

Also, if you need some more information, or would like to see some examples, you can click Learn More at the bottom of the auto-complete window for that function, and the Function Helper side panel will show up with a whole host of extra information for you.

Quick check-inAnchor Icon

OK, before we go on, let’s run a little test:

What’s the difference between a table and a page

A table is where you enter your information. A page is a group of tables.

What’s a two-dimensional range?

A two-dimensional range uses more than one row and column.

How should you format dates?

You should write them as YYYY-MM-DD and remember, if you write the date directly in a formula, use quoatation marks. For example: "2020-05-05".

What’s a function?

A function is a little program in the spreadsheet that'll give you a result based on the parameters you enter.

How should you enter text, dates, and numbers with operators?

Always in quotation marks. For example: "text", "2020-05-05", "<20".

Up nextAnchor Icon

And that’s it! With these basics under your belt, you’re going to be flying through advanced tutorials in no time! Don’t worry if you forget something - you can always come back to this lesson if you need a refresher.

So - I guess you want to learn something cool now, right? Well then, let’s get on to the next part of this course: using integrations 🚀.