Skip to main content

Tables

Lido tables are structured, named datasets that live inside your spreadsheet. Unlike ordinary ranges, Lido tables give each column a specific role — computed, linked, plain, or sourced from external data.

What is a Table?​

A table in Lido has:

  • A name used to reference it in other formulas
  • Columns with headers and different behaviors (computed, linked, plain, or source)
  • Rows of data that can come from external sources or be entered manually

Tables appear in your spreadsheet as a structured block of data. Once named, they can be referenced in other formulas and extended with additional column types.

Creating a Table​

There are two ways to create a table, depending on where the data comes from:

From an external data source​

Go to File → "Connect real-time data" and follow the setup wizard to connect a CRM, database, API, or other service. Lido will insert the necessary formulas and create the table automatically.

See External Data Sources for details.

From existing spreadsheet data​

Select a range of cells that already contains data (with headers in the first row), then right-click → "Create Table". Lido will turn the range into a named table.

See Lido Data as Source for details.

Adding Columns​

To add a new column to an existing table, start typing in a cell immediately to the right of the table. Lido will detect that you are extending the table and prompt you to choose a column type:

  • Computed — Enter a formula, and Lido applies it to every row automatically
  • Linked — Each row stores its own independent value, keyed by a unique ID column
  • Plain — An empty column for manual data entry

See Column Types for details on each type.

Referencing Table Data​

Once a table is named, you can reference its data in formulas using a special syntax:

SyntaxReturnsExample
TableName[@ColumnName]The value in that column for the current rowOrders[@Price]
TableName[ColumnName]The entire column as an arraySUM(Orders[Revenue])
TableName[#All]The entire table (all columns, all rows)FILTER(Orders[#All], Orders[@Status]="Pending")

Current-row references with @​

The @ prefix means "the value in this row". This is the most common form, used inside computed columns and formulas that sit next to a table:

=Orders[@Price] * Orders[@Quantity]

When Lido evaluates this inside a computed column, it resolves [@Price] and [@Quantity] to the values in the same row.

Entire-column references​

Without the @, a reference returns all values in the column as an array. This is useful for aggregate functions:

=SUM(Orders[Revenue])
=AVERAGE(Orders[Price])
=COUNTIF(Orders[Status], "Pending")

Whole-table references with #All​

TableName[#All] returns the entire table as a 2D range (including headers). This is useful when passing a full table to functions like FILTER or SORT:

=FILTER(Orders[#All], Orders[@Status]="Shipped")

Filtering and Sorting​

Use the filter and sort icons in the toolbar to filter rows by condition or sort by a column. These toolbar controls give you an interactive way to reshape the table view without writing formulas.

For more advanced transformations — or to create new derived tables from filtered/sorted results — see Transformations.

Sections​