# Formula Columns

Scorecard formula columns allows you to create a column that is derived from values in other columns. Here are some use cases for formula columns:

Once you click on Add a Formula Column, or edit an existing one, the system presents the column formula editor:

If the column formula editor looks familiar, it is because it is. It is the same editor used to defined scores. The only difference is that the variables available are columns that you have already added to the table, instead of response counts for question options. The columns are represented by labels of the format {c1} (for the first column), {c2} (for the second column), etc.

In the example above, the formula presents the spread between column 3 and column 2. If columns are reordered, the formula automatically update. **Please see Advanced Formulas for more on Formulas.**