DROPDOWN

Creates a single-value dropdown selector for a data field in a cell. Use to specify data field filter values: SUM(sales{brand{A1}}) where A1 contains =DROPDOWN(brand). For multi-value selection, see DROPDOWN_MANY.

Function syntax

DROPDOWN(field | filter, ... | option, ... | selected)

Arguments:

• field: The data field for the dropdown selector.
• filter, …: (optional) One or more data fields containing a filter value(s) that limit the values presented in the dropdown selector. Filter values can reference cells, including cells with DROPDOWN selectors.

Returns

The selected value. Returns blank if no values exist.

Examples

• DROPDOWN(brand) - Dropdown with all brand values.
• DROPDOWN(region | country{“USA”}) - Regions where country is USA.