- Blog

You can now do calculations on columns.

Calculating using other columns

As an example, let’s say you had two data columns (column A and column B) and wanted a third column to show the sum of A and B

Hover your mouse over third column’s type (It’s currently ‘Unknown’)

Now, click on ‘convert to formula column’. A window will pop up.

We want to add columns A and B, so type ‘col(A) + col(B)’ in the text box. Next, click on OK.

Done!

Filling in columns automatically using ‘row’

The first example showed you how to calculate using column data. You can also access the row number of a column. If, for example, you wanted a column with data like this:

You could fill it in automatically with a formula of ‘row * 10’:

For more on this, see Column Formulas Help in the Plot-O-Matic help section.