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, autocomplete, error messages all follow GSheets conventions. If you know GSheets, you know Table.



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 a default grid (A–G columns × 10 rows). Click any cell to start typing.



The selection pill — Table controls


Click the table to select it. Left to right:


  1. Edit resource (sliders icon) — opens the Table settings popover (title row, summary row, border — see below).
  2. Design (paintbrush icon) — opens the contextual Design panel (Layout & corners / Spacing / Background / Border / Effects on the widget container itself).
  3. ⋮ More — Edit resource (same as the sliders icon) · Duplicate · Delete.


(No Size / Dark mode / Replace / Expand — 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 the standard error code (e.g. #VALUE!, #REF!).


Supported formulas


The full list of built-in formulas — type = in any cell to see them in the autocomplete:


Function

What it does

Example

SUM

Sum of values

=SUM(A1:B5)

AVERAGE

Average of values

=AVERAGE(A1:B5)

COUNT

Count of numeric values

=COUNT(A1:B5)

COUNTA

Count of non-empty cells

=COUNTA(A1:B5)

MIN

Minimum value

=MIN(A1:B5)

MAX

Maximum value

=MAX(A1:B5)

MEDIAN

Median value

=MEDIAN(A1:B5)

STDEV

Standard deviation

=STDEV(A1:B5)


Fonction

Ce qu'elle fait

Exemple

SUM

Somme des valeurs

=SUM(A1:B5)

AVERAGE

Moyenne des valeurs

=AVERAGE(A1:B5)

COUNT

Nombre de valeurs numériques

=COUNT(A1:B5)

COUNTA

Nombre de cellules non vides

=COUNTA(A1:B5)

MIN

Valeur minimale

=MIN(A1:B5)

MAX

Valeur maximale

=MAX(A1:B5)

MEDIAN

Valeur médiane

=MEDIAN(A1:B5)

STDEV

Écart-type

=STDEV(A1:B5)


Adding & managing rows and columns


  • Add a row at the bottom — the + button under row 10.
  • Add a column to the right — the + at the far right of the column header.
  • Insert / duplicate / delete a rowright-click the row number to open the row context menu:
    • Insert row above
    • Insert row below
    • Duplicate row
    • Delete row
  • Insert / duplicate / delete a columnright-click the column letter for the same operations on columns.



Table settings — Edit resource popover


Open via the sliders icon on the pill. Three groups of settings shape the whole table:


  • Title row — toggle (on by default). When on, the first row is treated as a header row with its own background color.
  • Summary row — toggle (off by default). When on, an extra summary row is appended at the bottom, with its own background color. Useful for totals, averages, or any roll-up of the cells above.
  • Border — color (hex picker) and width (px). Applied to every cell boundary.


  • Ligne de titre — interrupteur (activé par défaut). Lorsqu'il est activé, la première ligne est traitée comme une ligne d'en-tête avec sa propre couleur de fond.
  • Ligne de synthèse — interrupteur (désactivé par défaut). Lorsqu'elle est activée, une ligne de synthèse supplémentaire est ajoutée en bas, avec sa propre couleur de fond. Utile pour les totaux, les moyennes ou tout récapitulatif des cellules au-dessus.
  • Bordure — couleur (sélecteur hex) et épaisseur (px). Appliquée à chaque bordure de cellule.


Best practices


  • Bold your header row — turn on Title row so buyers know at a glance where the labels are.
  • Roll-up in the summary row=SUM(B2:B10), =AVERAGE(C2:C10). Keeps your totals 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: 18/06/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!