> ## Documentation Index
> Fetch the complete documentation index at: https://coconut-grid.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Columns

Configure the columns displayed in the data grid. You can add fields, create formula columns, and manage column settings.

## Add Column

Add a new column from a field or a formula.

### Add Field Column

**1. Open Columns Dialog**

From the data grid menu, click **Columns**.

**2. Open Fields Tab**

Select the **Fields** tab.

**3. Select Field**

Turn on the checkbox next to a field in the field picker.

**4. Add to Columns**

The field is added to **Selected Columns**.

> [!TIP]
>
> For field details, see [Fields](https://coconut-grid.mintlify.site/visualization/fields.md).

### Add Formula Column

**1. Open Columns Dialog**

From the data grid menu, click **Columns**.

**2. Open Formula Tab**

Select the **Formula** tab.

**3. Enter Formula Details**

Enter the required information.

| Field | Description |
| - | - |
| **Column Label** | The header text shown in the data grid |
| **Data Type** | The formula’s output type |
| **Formula** | Expression using fields, operators, and functions |
| **Treat blank fields as zeroes / blanks** | How blanks are evaluated |

**4. Validate**

Click **Validate** to check the formula.

**5. Add**

Click **Add** to create the formula column.

> [!TIP]
>
> For syntax, operators, and functions, see [Formulas](https://coconut-grid.mintlify.site/visualization/formulas.md).

## Edit Column

Update column settings.

**1. Open Column Menu**

From a column header or **Selected Columns**, open the column dropdown menu.

**2. Select Edit**

Click **Edit** to open the dialog.

**3. Update Column Details**

Modify the required information.

| Field | Description |
| - | - |
| **Label** | The header text |
| **Alias** | Column alias |
| **Name** | Column system name |
| **Hidden** | Hide the column |
| **Column Type** | Column type |
| **Data Type** | Output type |
| **Header Align** | Alignment of the column header |
| **Text Align** | Alignment of cell values |
| **Formula** | Formula expression |
| **Treat blank fields as zeroes / blanks** | Calculation behavior |

**4. Save**

Click **Save** to apply changes.

## Clone Column

Create a new column by copying an existing column.

**1. Open Column Menu**

In **Selected Columns**, open the column dropdown menu.

**2. Select Clone**

Click **Clone** to open the dialog.

**3. Update Column Details**

Modify the copied settings as needed.

**4. Save**

Click **Save** to create the column.

## Delete Column

Remove a column from the data grid.

**1. Open Column Menu**

From a column header or **Selected Columns**, open the column dropdown menu.

**2. Select Delete**

Click **Delete** to remove the column.

> [!TIP]
>
> For field columns, you can also remove them by turning off the checkbox in the field picker.

## Hide Column

Hide a column without deleting it.

**1. Open Column Menu**

From a column header or **Selected Columns**, open the column dropdown menu.

**2. Select Hide**

Click **Hide**.

**3. Show**

Click **Show** to display the column again.

> [!TIP]
>
> Hidden columns appear semi-transparent in **Selected Columns** but are not displayed in the data grid.

## Reorder Column

Change the display order of columns.

* **Drag in Data Grid**: Drag a column header left or right.
* **Reorder in Dialog**: In **Selected Columns**, drag columns or use menu actions.

## Pin Column

Keep a column visible while scrolling.

**1. Open Column Menu**

From a column header, open the column dropdown menu.

**2. Select Pin**

Choose **Pin to left** or **Pin to right**.

**3. Unpin**

Select **Unpin** to return to normal.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.