Articles on: Rooms

Table widget

The Table widget is a mini-spreadsheet inside your room. Excel-style cells, GSheets-style formulas. Use it for pricing tables, ROI breakdowns, scoring grids, configurator output — anything where buyers want numbers in rows and columns.


Behaves like Google Sheets — formulas, cell references and autocomplete follow the conventions you already know. The function set is deliberately small (see below).



How to add


  1. On the floating build bar at the bottom of the editor, open the ⌄ All widgets popover and locate Table.
  2. Drag it onto the target section.
  3. The widget drops in with four named columns — Item · Qty · Unit Price · Total — and one empty row. Click any cell to start typing, and click a column header to rename it.



The selection pill — Table controls


Click the table to select it. Left to right:


  1. Ask AI (gradient AI mark).
  2. Edit content (settings icon) — opens the Table settings popover (title row, summary row — see below).
  3. Design (paint bucket icon) — opens the contextual Design panel (Layout & corners / Spacing / Background / Border / Effects on the widget container itself).
  4. ⋮ More — Duplicate · Delete.


(No Open / S-M-L — none apply.)


Editing cells


Click any cell and type. Behaviour mirrors a standard spreadsheet:


  • Plain text or numbers — type and press Enter (moves down) or Tab (moves right).
  • Formulas — start with = to enter formula mode. An autocomplete dropdown lists available functions with usage examples and short descriptions. Pick one to insert it.
  • Cell references — use A1, B2, etc. Ranges use the colon notation: A1:B5.
  • Errors — a cell whose formula can't be resolved shows #ERR in the error style; a formula that ends up referring back to its own cell shows #CYCLE.


Supported formulas


The full list of built-in functions — type = in any cell to see them in the autocomplete, each with its usage hint:


Function

What it does

Example

SUM

Add cells

=SUM(A1:A3)

AVG

Average

=AVG(A1:A3)

COUNT

Count numeric cells

=COUNT(A1:A3)

MIN

Smallest value

=MIN(A1:A3)

MAX

Largest value

=MAX(A1:A3)

ROUND

Round to N decimals

=ROUND(A1, 2)

IF

Conditional

=IF(A1>0, B1, C1)


Circular references resolve to #CYCLE.



Adding & managing rows and columns


Row and column gutters appear when the table is selected.


  • Add a row at the bottom — the + just under the last row number.
  • Insert / duplicate / delete a row — right-click the row number to open the row context menu:
    • Insert row above
    • Insert row below
    • Duplicate row
    • Delete row
  • Insert / duplicate / delete a column — right-click the column letter for the column menu:
    • Insert column left
    • Insert column right
    • Duplicate column
    • Delete column


Left-clicking a row number or column letter selects it (so a stray click never deletes anything); the Delete key then clears the selection.



Table settings — the Edit content popover


Open via the settings icon on the pill. Two settings shape the whole table:


  • Title row — toggle (on by default). When on, the named header row is shown, and a Background colour field appears under the toggle.
  • Summary row — toggle (off by default). When on, an extra summary row is appended at the bottom, with its own Background colour field. Useful for totals, averages, or any roll-up of the cells above.


Cell borders come from the Design panel on the widget, not from this popover.


The summary row is per-column


Each cell of the summary row carries its own roll-up. Click a summary cell and pick from No summary · Sum · Average · Count · Min · Max — the label and the computed value then show in that cell, recomputing as the column above changes. An unset cell reads + formula.



Best practices


  • Name your columns — turn on Title row and rename the headers so buyers know at a glance what each column holds.
  • Use the summary row for roll-ups — pick Sum or Average per column instead of hand-writing a total. Totals then stay dynamic.
  • Keep tables compact — Tables are for quick scan + a few numbers. If you need 200 rows, attach an XLSX in a Document widget instead.


Updated on: 01/10/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!