> For the complete documentation index, see [llms.txt](https://docs.getconduit.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getconduit.app/workflows/workflows-adding-new-columns.md).

# Workflows – Adding New Columns

Conduit's Workflows functionality enables users to integrate additional columns into their existing datasets, by several different ways

#### Add Metric

The first way is to add a new column with a new metric with a custom formula to the existing dataset. To do so, just drag the Add Metric block on your workflow's canvas 

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

Now, let's apply a custom formula to the block and add the 'Save to Google Sheet block'. In our case, the formula would be the sum of Clicks and Link Clicks parameters and we'll also name the metric as 'TotalClicks'&#x20;

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

Run the workflow and check the results. You should the TotalClicks column in the output sheet&#x20;

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

#### Add Column

The second method involves adding of a new column with a fixed value, whether it be an integer, string, decimal, or other data type.&#x20;

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

#### If Then

Third method of adding a new column is using the If Then block. This block allows adding a new column to the dataset if certain specified conditions are met.&#x20;

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

#### Applying Macros

You can apply macros to the 'Add Metric' and 'Add Column' blocks and then use them in your custom formulas. Currently, there are two types of macros available:

1. Workflow's date range start
2. Workflows date range end

**Use-case example:**

The macros could be used for calculating the average ad spend over the date range of interest. Let's say, you can create the two columns, that would stand for the date range and apply the Add Metric block to calculate the number of days. Then, you can apply the additional Add Metric block and have it to divide the overall ad spend to the number of days