The Toggle block is an on/off switch. When on, it contributes a value you configure to the spreadsheet; when off, it contributes 0. This article covers its value, display, and cell assignment.
What it does
A Toggle renders a switch next to the block title. Its Value when on is used for its cell when on, and 0 when off. Use it for yes/no add-ons — an extra warranty, a service upgrade, anything that toggles a fixed amount in or out of a calculation.
Adding one
- In the Input tab, click + Add and choose Toggle.
- Click the block to open its settings.
Settings
Formula
In the Formula group, click Assign to bind the toggle to a spreadsheet cell. See Assigning input blocks to cells.
General
The General group has the shared title, description, and hover hint controls. See Common block settings.
Value
- Value when on — the number used for the cell when the toggle is on. Off always uses
0. - Show numeric value — when on, the configured value is shown as a light pill next to the switch.
- Display as — appears only while Show numeric value is on. Choose Number, Currency, or %; picking Currency reveals a currency picker. See Number formats.