Building Blocks

Dropdown block

Updated 2026-09-02

The Dropdown block lets a visitor pick one option from a list, and feeds that option's numeric value into your spreadsheet. This article covers building the options list, showing values, and importing options in bulk.

What it does

A Dropdown is single-select: the visitor chooses exactly one option. Each option has a label (what the visitor sees) and a value (the number behind it). When an option is selected, that value is substituted into the block's assigned cell when the calculator runs.

Adding one

  1. In the Input tab, click + Add and choose Dropdown.
  2. Click the block to open its settings.

Settings

Formula

In the Formula group, click Assign to bind the dropdown to a spreadsheet cell. The selected option's value is substituted there at run time. See Assigning input blocks to cells.

General

The General group has the shared title, description, and hover hint controls. See Common block settings.

Options

  • Show numeric value — when on, each option displays its value beside the label as a light pill (for example 12,400), so visitors can see the number behind their choice.
  • Display as — appears only while Show numeric value is on. Choose Number, Currency, or %; picking Currency reveals a currency picker. See Number formats.
  • Options — click the options row, which reads for example 4 options followed by Edit, to open the options drawer.

Building the options list

Open the options drawer and add a row for each choice with + Add. Give every option a Label and a Value. Once the list passes five options, a search box appears so you can jump to one by label.

To add many options at once, use the Import CSV button in the drawer. See Importing options from CSV.

Single-select only

The Dropdown is always single-select. If you need visitors to pick more than one option and sum the values, use the Selection block with Allow multiple answers turned on instead.

Dependent dropdowns

You can chain dropdowns so a child dropdown only shows the options that belong to the visitor's choice in a parent dropdown. See Cascading (dependent) dropdowns.

Related