Skip to content
Agenda Agenda Docs

Creating tables & using formulas

This page shows how to use tables in practice — from your first new table to formulas across cells.

Create a new table

  1. Open Tables in the side menu.
  2. Click New table.
  3. Pick the number of columns, rows and the header type:
    • Top — the first row is the header.
    • Left — the first column is the header (e.g. for employee names).
    • Top + Left — both, like a classic matrix.
    • None — pure data table without highlighted headers.
  4. Give the table a clear title.
  5. Optional: attach the table to a project or subproject.
  6. Click Create.

Type in values

Click a cell, type the value, press Tab (next column) or Enter (next row).

Several tables side by side

On the web you can show multiple tables per row — handy for side-by-side comparisons or when you keep similar structures for several employees or sites.

  1. Click the layout icon at the top.
  2. Pick 1 / 2 / 3 per row.
  3. Existing tables rearrange automatically.

Using formulas

A formula is a calculation in a cell that references other cells. Tables support simple operations and a free-form input field for more complex formulas.

Simple formula (plus / minus / times / divided by)

  1. Click the cell where the result should appear.
  2. Open the Formula panel (calculator icon).
  3. Pick the operation, e.g. +.
  4. Enter the two source cells, e.g. “B2” and “C2”.
  5. Confirm. The target cell shows the result and updates as soon as one of the sources changes.

Percentage

The formula panel has a Percent tab. Enter the source cell and the percentage value — e.g. “B2 + 19%” — and the result lands in the target cell.

Advanced formula

For more complex calculations, type into the Advanced formula field. You can combine parentheses, several operations and references to any number of cells.

Format cells

  • Colour — select a cell and pick a background colour (e.g. to mark mandatory fields or anomalies).
  • Multi-line text — cells wrap automatically when the text exceeds the column width.

Undo / redo

Click Undo (back arrow) or Redo (forward arrow) at the top. The last changes are kept in a list and can be reverted one by one.

Saving

Tables are saved automatically — values and formulas alike. No extra save button is needed. If you close the window or the app your work is safe.