The Toggle block is an on/off switch. When on, it sends a value you configure to the spreadsheet; when off, it sends 0. This article covers its value, display, and cell assignment.
What it does
A Toggle renders a switch next to the block title. Flipping it on writes your configured Value to the assigned cell; flipping it off writes 0. 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 Build tab, click + Add in the input area 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. The cell receives your configured value when on, or 0 when off. See Assigning input blocks to cells.
General
The General group has the shared title, description, tooltip, block spacing, and background controls. See Common block settings.
Value
- Show Value — when on, the configured value is shown as a label next to the switch (formatted per your number format).
- Number Format and Currency — control how the value is displayed. See Number formats.
- Value — the number sent to the cell when the toggle is on. Off always sends
0.