> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Value lists

> Build organized Sigma value lists from formulas, controls, and data sources, or create dynamic lists with containers.

To create an organized view of details from one or more data sources, add a value list element. You can customize the value list to show custom formula results, values from controls, static values, and more. When paired with a [single row container](/docs/use-single-row-containers-to-show-records-in-detail), you can create a dynamic list that shows individual rows from a data source based on user input. To see an example of a value list paired with a single row container, see [Example: Create an interactive employee directory](/docs/use-repeated-containers-to-generate-layouts-from-data#example-create-an-interactive-employee-directory).

This document explains how to create and customize a value list element.

## User requirements

To add and edit value list elements:

* You must have **Can edit** or **Can explore** [access](/docs/folder-and-document-permissions#document-permissions) to the individual workbook.
* You must be in **Edit** or **Explore** mode for the workbook. See [workbook modes overview](/docs/workbook-modes-overview).

## Create a value list element

To add a value list element to a workbook:

1. Open a draft, custom view, or saved view of a workbook.
2. In the **Add element** bar, select **UI** > **Value list**. The new value list element appears on the page.

![An empty value list element on a workbook page. It contains three empty fields.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/034ce8113abc6bdcb817495d12a34e68467b883f3aa1b531d426812aee72b78d/assets/docs-images/0a27b7207011f7649fb66f7c3769c8f672748154a7b8cfc4186e364e2f214a6a-Empty_Value_List.png)

## Customize fields in a value list

To control what information is displayed in the value list, you can add and customize fields:

* [Configure a field in a value list](#configure-a-field-in-a-value-list)
* [Add a field to a value list](#add-a-field-to-a-value-list)
* [Remove a field from a value list](#remove-a-field-from-a-value-list)
* [Organize fields in a value list](#organize-fields-in-a-value-list)

### Configure a field in a value list

1. Select the value list element on the workbook page.

2. In the editor panel, under **Properties**, in the **Fields** section, select the field you want to configure.

3. If the value list is connected to a single row container or repeated container, choose whether to display a value from a **Source column** or a **Formula**. Otherwise, you can only configure fields using a formula.

4. If the value list is connected to a single row container, choose whether to display a value from a **Source column** or a **Formula**. If it is not connected to a single row container or repeated container, you can only configure fields using a formula.

   * For **Formula**, use the formula bar in the **Value** section to configure the value of the field. Optionally, enter a **Label** for the field.

![A value list field configured with a formula.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/54dbd8f0b9d5fd416cb2e77ae22b541e59c329e47fde924ea071e16fc1b40915/assets/docs-images/da38c518129be83439e3d1c5fb86606a6c5769138cfcfb9c1a43033774fe91b3-Populate_Field_in_Value_List_with_Formula.png)

* For **Source column**, select a column from the connected data source in the **Value** section. Optionally, enter a **Label** for the field.

![A value list field configured with a data source.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/90eb92df6b905762ed55ea173251608fba1f5d84237d0413ac3f691c0563a265/assets/docs-images/5db874e68f8e7cca34d18aa550b56fb4af1138882301daaa9fd864d52231f648-Populate_Value_List_from_Data_Source.png)

Fields in a value list can only display one value. If your selected data source or formula returns multiple values, the field reads *Multiple values*. Consider changing the data source or applying an [Aggregate function](/docs/aggregate-functions).

### Add a field to a value list

1. Select the value list element on the workbook page.
2. In the editor panel, under **Properties**, in the **Fields** section, click <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/add.svg" alt="" /> **Add field**. A new field appears at the bottom of the section.
3. Select the new field to configure its contents.

### Remove a field from a value list

1. Select the value list element on the workbook page.
2. In the editor panel, under **Properties**, in the **Fields** section, click <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/more.svg" alt="" /> **More options** for the field you want to remove.
3. Click **Delete**.

### Organize fields in a value list

1. Select the value list element on the workbook page.
2. In the editor panel, under **Properties**, in the **Fields** section, drag and drop fields to organize them in the desired order.

## Customize value list

You can customize the appearance of the value list and its fields.

1. In the editor panel, select the **Format** tab.

2. In the **Element style** section, customize the following:

   * **Padding**: On by default. Turn off the toggle to remove padding between elements.
   * **Background color**: Change the background color of the value list using a hex code, color palette, or color picker.
   * **Border**: Add a border around the value list.
   * **Corner**: Select whether to have square, round, or pill-shaped corners for the value list.

3. In the **Field style** section, customize the following:

   * **Label format**: Change the font size, weight, and color of the field label.
   * **Value format**: Change the font size, weight, and color of the field value.
   * **Layout**: Choose whether to organize fields and labels in a grid, compact, separated, or stacked layout.