# Formula Column

<figure><img src="/files/AeRXPCrjQUqrF3oXyAq3" alt=""><figcaption></figcaption></figure>

## Overview

The New Column Node allows you to add new columns to your dataset based on formulas, including existing column values and various functions.

<figure><img src="/files/S1AyM2YL66oczh6jrJuo" alt=""><figcaption></figcaption></figure>

## **Settings**

You can create new columns, specify their names, and define the expressions or formulas to calculate the values for the new columns.

#### **Set Value To**

Use the "Set Value To" property to define the expression or formula for calculating the values in the new column. The expression editor provides autocomplete functionality, helping you easily access functions and column names.&#x20;

An expression can consist of:

* text -> <mark style="color:green;">"my\_string"</mark> (always frame text with double quotes)&#x20;
* numbers -> <mark style="color:orange;">1.2</mark>  (use a period to separate the integral and fractional parts of decimal types.)&#x20;
* column names -> My\_Column (start typing column name and use auto-suggestions to add column reference)&#x20;
* functions -> <mark style="color:blue;">Round</mark>(<mark style="color:orange;">1.2234</mark>, <mark style="color:orange;">2</mark>)

See the full list of operators in our tutorial [What are Formulas?](/data-transformation/formulas/what-are-formulas.md)

#### **Column Name**

The "Column Name" property allows you to specify the name for the new column. By default, the new column will be added to the dataset. If you want to overwrite an existing column instead, enable the "Overwrite" toggle and select the column you want to overwrite from the list.

#### +Add Column

<div align="left"><figure><img src="/files/qxSTIF1S7p4o3ClTfnxA" alt="" width="380"><figcaption></figcaption></figure></div>

To add more new columns, click the "Add Column" button. You can create multiple new columns with unique names and expressions.

You can reference any columns added earlier in this node.

## **Preview**

New columns will appear in the dataset, showing the calculated values based on the expressions or formulas you defined.

<div align="left"><figure><img src="/files/fIgu3DfAwWCRbMgsJ0Fd" alt="" width="563"><figcaption></figcaption></figure></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tabula.io/data-flows/tools-nodes/columns-operations/formula-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.