Sheet User Guide
A full spreadsheet inside your workflows — Excel-compatible formulas, live charts, and AI assistance.
The Sheet gives you a familiar spreadsheet that also plugs into everything else in Circuitry. Edit data visually, compute with formulas, connect to data backends, and pass results downstream.
Excel-compatible formulas
Paste your formulas straight in and they just work. Functions, cell references, ranges, and the keyboard shortcuts you already know behave the way you expect — no relearning.
Rows, columns and sorting
- Click a column letter or a row number to select the whole column or row. Shift-click or drag across the letters or numbers to select several.
- Right-click a column letter, a row number or selected cells — or press and hold on a touch screen — to cut, copy, paste, insert or delete rows and columns, clear contents, or sort.
- Sort A → Z or Z → A from a column letter to sort the whole sheet by that column, or select a block of cells to sort just that block. Rows stay together, empty cells go last, and if your first row holds labels tick First row is a header to keep it in place.
- Formulas follow the cells they refer to when you insert or delete rows and columns. A formula that points at a deleted cell shows #REF!.
Column widths, row heights and wrapping
- Drag the right edge of a column letter to change its width, or the bottom edge of a row number to change its height. Double-click an edge to fit the column or row to its content.
- A row taller than one line wraps its text. If the text still doesn't fit, the end is cut off; select the cell to read all of it in the formula bar.
- When data arrives from an import, an online sheet or an agent, the sheet sets its own layout: short columns fit their longest value, long text columns such as notes stay at a readable width and wrap, and their rows grow (up to six lines).
- To lay out the sheet again, choose Edit → Auto-size Cells. It sizes the selected cells, or the whole sheet if you have only one cell selected.
- Columns and rows you size yourself are never changed by automatic layout. To lay out again, right-click a column letter and choose Auto-fit layout (wrap long text) for the selected columns, or Auto-fit whole sheet. Right-click a row number and choose Fit row height to fit selected rows.
Connect to multiple backends
A Sheet isn't limited to typed-in values. Pull data from multiple backends, edit it visually, and push it back — so the spreadsheet becomes a live view over your data rather than a static file.
Charts that stay in sync
Connect a Sheet to a chart and the visualization updates as the data changes — bar, line, scatter, pie, area, and more. Great for dashboards and quick analysis.
AI Data Wizard
Generate and transform data in plain English with the AI Data Wizard — "add a moving average column," "fill in sample rows," "group and total by month."
Loop over rows
Hand a Sheet to a Loop to run each row through the rest of a workflow — call an API per row, process a file per row, or ask an agent about each record.
Tips
- Name your sheets descriptively — you'll reference them by name elsewhere.
- Keep raw data and computed views separate for cleaner pipelines.
- Use charts for instant feedback while you shape the data.