Spreadsheets: tables, slicers and timelines

These tools help you keep a list of things — tasks, orders, people, events — organized in SingleSign Spreadsheets. For the basics (entering data, formatting, filters and charts), see Spreadsheets.

Tables

A table turns a plain range into a structured list: a header row, a type for each column, colors, and optional totals.

Format ▸ Convert to table (Ctrl+Alt+T) converts the range you've selected — or, if you've only selected one cell, the block of data around it. Empty headings become "Column 1", "Column 2" and so on. Tables can't overlap each other or contain merged cells.

The Table panel opens on the right (later, click in the table and choose Format ▸ Table settings):

Table name and Table range.
Color, Alternating colors and a Totals row.
Columns — each column's type: Text, Number, Percent, Currency, Date, Dropdown (with its own list of options), Checkbox, People (smart chip) or Smart chip. The type sets the column's number format and checks what's typed into it. With a totals row, each column picks its Total: None, Sum, Average, Count numbers, Count, Max or Min.
Revert to range — turns the table back into ordinary cells, keeping the data.

A table grows by itself: type in the row just below it, or the column just to its right, and the new row or column becomes part of the table. Each heading has a filter button for sorting and filtering the table's rows.

Structured references

Formulas can refer to a table and its columns by name instead of by cell address, and the reference keeps working as the table grows or moves:

Reference	Means
`Table1`	The table's data rows.
`Table1[Amount]`	The data in the Amount column.
`Table1[[Start]:[End]]`	The columns from Start to End.
`Table1[#All]`, `[#Data]`, `[#Headers]`, `[#Totals]`	The whole table, just the data, just the header row, just the totals row.
`Table1[@Amount]` or `[#This Row]`	The Amount value in the same row as the formula.

For example, =SUM(Orders[Amount]) totals a column however many orders you add. Renaming a column heading updates every formula that refers to it, and Revert to range turns structured references back into ordinary cell references.

Slicers

A slicer is a small filter control that floats over the sheet — a quick way for anyone looking at a dashboard to narrow the data down.

Select your data, header row included, and choose Data ▸ Add a slicer.
In the Slicer panel, pick the Column to filter by, and optionally a Title and Color.
Click the slicer to filter by values — tick the ones to show, with a search box for long lists. The panel also has Filter by condition (Is empty, Text contains, Greater than, Is between, Custom formula is and more).

A slicer hides rows the same way a filter does, so charts and SUBTOTAL follow it. Tick Apply to pivot tables to filter pivot tables built from the same data too. Drag a slicer to move it; its ⋮ menu has Edit slicer and Delete slicer. Only editors can change a slicer.

Timeline view

View ▸ Timeline (or Insert ▸ Timeline) shows the rows of a range as cards on a time axis — good for project plans, events and schedules.

In the Timeline view panel, choose the Data range (with headers) and the Start date column. Optionally pick an End date, and the columns used for each card's title, color, group and details. Cards in the same group share a lane.

Zoom in and out, or pick day, week, month, quarter or year. Click a card to select its row in the sheet. Rows without a valid start date aren't shown (the panel says how many were skipped). A sheet can have several timelines — switch between them from the list at the top, and use the settings and delete buttons beside it.

Named functions

Data ▸ Named functions lets you turn a formula you use often into your own function — for example MARGIN(revenue, cost).

Function name — capital letters, such as PROFIT_MARGIN.
Function description, Argument placeholders (comma-separated) and a description for each argument, shown as help while people type.
Formula definition — written with the placeholders, for example =(revenue - cost) / revenue. Use the placeholders instead of cell references; named functions can call other named functions.

A named function works in every cell of the spreadsheet, and Import function copies named functions from another spreadsheet you can open. If a name matches a built-in function, the built-in one wins. Renaming a named function updates every formula that uses it.

Smart chips in cells

Type @ at the start of a cell (or after a space), or choose Insert ▸ Smart chips, to insert:

People — someone from your contacts or organization. Hover the chip to see their address, with a button to email them.
Files — a Writer document or spreadsheet, which opens from the chip.
Dates — Today, Tomorrow, Yesterday or the Date picker.
Dropdown — adds a dropdown to the cell.
Finance — type a ticker after the @ (such as @NASDAQ:GOOG) for a chip that shows its latest quote on hover, when a market-data provider is available.
Place — type a place name for a chip with Open in Maps on hover.

The chip's text is the cell's value, so formulas, sorting and filtering see the name, date or symbol.

Cleanup suggestions

Data ▸ Data cleanup ▸ Cleanup suggestions checks your data and suggests fixes for:

extra spaces before, after or inside values;
inconsistent capitalization in a column;
numbers stored as text;
dates written in inconsistent formats;
duplicate rows.

Each suggestion has Apply (or Remove for duplicates) — one click, and you can undo it. It only changes values you typed, never formulas. If everything's fine, you'll see "Your data looks clean — no suggestions." The same menu still has Remove duplicates and Trim whitespace for doing it yourself.

Spreadsheets
Formulas and functions reference
AI features — Help me organize builds a table for you