Refreshing the spreadsheet basics

Get a refresher on spreadsheets.

Intro

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

These are the absolute basics

This is part one of our 6-part series (30min total) about Rows for Beginners. If you already know your way around spreadsheets, you can skip this article and instead start with Using integrations.

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

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

Basic terms

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

Spreadsheet, table, and page

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 data “sheet” where you can enter your data.
  • Page: A Page is where you place Tables, which you can arrange into a nice layout.

kb-spreadsheet-newUI

Maximum number of tables on a page

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

Rows and columns

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 ranges

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.

One-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 booleans

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 formula

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.

Returns

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 function

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 types

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 references

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 quotation 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 Helper

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-in

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".

Conclusion

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

More for Beginners

Want to learn more? Well then, check the rest of our Rows for Beginners series:

  1. Refresh the spreadsheet basics (you're here)
  2. Using integrations: Up next! 🚀
  3. Working with data
  4. Installing templates
  5. Collaborating in workspaces
  6. Making your spreadsheet go Live!