Concept: Switches, Check Boxes, and Drop-Down Lists in Sheets

Switches, check boxes, and sometimes drop-down selections, activate formulas using data on the same sheet or another sheet in your model. Example: If you switch on a health benefit, it may use other data, like salary and headcount, to calculate personnel expenses.

Drop-down selections may also be informational labels or custom dimensions or attributes in your model used for slicing, categorizing, and tagging data.

Select check boxes to activate or clear. For toggle switches, select the switch to turn it on or off. Unsaved changes to check boxes and toggle switches are blue. Saved changes are green or gray:

To select an item from a cell with a drop-down list:

If the drop-down list of the cell contains dimensions or dimension attributes, use them as filters in other related drop-down lists in modeled sheets. You may also be able to change or add to the selections available. See Change Cube Sheet View and Change Modeled Sheet View.