> ## 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

<Steps>
  <Step title="Open Columns dialog">
    From the data grid menu, click **Columns**.
  </Step>

  <Step title="Open Fields tab">
    Select the **Fields** tab.
  </Step>

  <Step title="Select field">
    Turn on the checkbox next to a field in the field picker.
  </Step>

  <Step title="Add to columns">
    The field is added to `Selected Columns`.
  </Step>
</Steps>

<Tip>
  For field details, see [Fields](/data-grid/fields).
</Tip>

### Add Formula Column

<Steps>
  <Step title="Open Columns dialog">
    From the data grid menu, click **Columns**.
  </Step>

  <Step title="Open Formula tab">
    Select the **Formula** tab.
  </Step>

  <Step title="Enter formula details">
    Enter the required information.

    * `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
  </Step>

  <Step title="Validate">
    Click **Validate** to check the formula.
  </Step>

  <Step title="Add">
    Click **Add** to create the formula column.
  </Step>
</Steps>

<Tip>
  For syntax, operators, and functions, see [Formulas](/data-grid/formulas).
</Tip>

## Edit Column

Update column settings.

<Steps>
  <Step title="Open column menu">
    From a column header or `Selected Columns`, open the column dropdown menu.
  </Step>

  <Step title="Select Edit">
    Click **Edit** to open the dialog.
  </Step>

  <Step title="Update column details">
    Modify the required information.

    * `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
  </Step>

  <Step title="Save">
    Click **Save** to apply changes.
  </Step>
</Steps>

## Clone Column

Create a new column by copying an existing column.

<Steps>
  <Step title="Open column menu">
    In `Selected Columns`, open the column dropdown menu.
  </Step>

  <Step title="Select Clone">
    Click **Clone** to open the dialog.
  </Step>

  <Step title="Update column details">
    Modify the copied settings as needed.
  </Step>

  <Step title="Save">
    Click **Save** to create the column.
  </Step>
</Steps>

## Delete Column

Remove a column from the data grid.

<Steps>
  <Step title="Open column menu">
    From a column header or `Selected Columns`, open the column dropdown menu.
  </Step>

  <Step title="Select Delete">
    Click **Delete** to remove the column.
  </Step>
</Steps>

<Tip>
  For field columns, you can also remove them by turning off the checkbox in the field picker.
</Tip>

## Hide Column

Hide a column without deleting it.

<Steps>
  <Step title="Open column menu">
    From a column header or `Selected Columns`, open the column dropdown menu.
  </Step>

  <Step title="Select Hide">
    Click **Hide**.
  </Step>

  <Step title="Show">
    Click **Show** to display the column again.
  </Step>
</Steps>

<Tip>
  Hidden columns appear semi-transparent in Selected Columns but are not displayed in the data grid.
</Tip>

## Reorder Column

Change the display order of columns.

<Steps>
  <Step title="Drag in data grid">
    Drag a column header left or right.
  </Step>

  <Step title="Reorder in dialog">
    In `Selected Columns`, drag columns or use menu actions.
  </Step>
</Steps>

## Pin Column

Keep a column visible while scrolling.

<Steps>
  <Step title="Open column menu">
    From a column header, open the column dropdown menu.
  </Step>

  <Step title="Select Pin">
    Choose **Pin to left** or **Pin to right**.
  </Step>

  <Step title="Unpin">
    Select **Unpin** to return to normal.
  </Step>
</Steps>