Interactive Dropdowns and Linked Metrics

A static report shows one fixed view. An interactive dashboard lets the reader pick what they want to see, and the numbers respond instantly. The key tool is a dropdown selector wired into your formulas.

The idea is simple: a single cell holds the user's choice, such as a region or month. Every metric on the dashboard references that one cell. Change the dropdown, and the entire dashboard recalculates around the new selection.

In this lesson you will build a dropdown and link totals, counts, and filtered views to it.

A dropdown comes from Data Validation. Select the selector cell, for example B1, then open Data, Data Validation, and choose List.

For the source you can point at a range of valid options:

• Source range: =Lists!A2:A6 holding East, West, North, South, All.
• Or generate the list with a formula like =SORT(UNIQUE(Sales!A2:A500)) in a helper column and point the validation at it.

Now B1 shows a little arrow and only accepts a value from your list. That single cell becomes the control knob for the dashboard.