Data tables
Tables that do the sums
Typed columns inside your docs, with formulas that work out each row as you type.
Change a quantity and the total works itself out.
Try it
A column that does the maths
Change a quantity and the total follows, as it would in a spreadsheet.
- Columns for text, numbers, money, choices, contacts, deals and projects
- Formula columns, written with column names
- A total, an average or a count under any column
In practice
What Data tables give you
Typed columns
Text, numbers, money, percentages, checkboxes, emails, links and phone numbers, each shown the way it should be.
Choices with colours
Select and multi-select columns with your own coloured options, created as you type.
Linked to your records
Contact, deal and project columns hold the record itself. Click one to go straight to it.
Formulas
Write {Price} * {Qty} and every row works itself out. Rename a column and the formula keeps up.
Totals underneath
A sum, an average, a median or a count under any column, worked out as you edit.
Sorted your way
Sort the rows by any column, and drag rows and columns into the order you want.
How it works
Data tables in three steps
Add a table
Type /datatable in any doc, or turn an ordinary table into one.
Give each column a type
Number, currency, a select with coloured options, a contact, a deal, a project or a formula.
Let it do the sums
Formulas and totals update as you type.
Goes well with
Whiteboards
A whiteboard in any doc, for drawing ideas out together.
Reports
How every part of the business is moving, over any period.
Projects
Milestones, a board, a calendar and a timeline for the work you deliver.
FAQ
Questions about Data tables
Inside docs. Type /datatable, or turn an ordinary table into a data table.
Yes. A contact, deal or project column holds the record itself, found by searching as you type, and a click on it opens the record.
Text, long text, number, currency, percentage, select, multi-select, checkbox, email, URL, phone, contact, deal, project and formula.
Add, subtract, multiply, divide and raise to a power using the other cells in the same row, with brackets and functions such as SUM, AVG, ROUND and MAX.
Yes. Everyone in the doc edits the same table, and each person's changes are kept.
Get started
Give your big goal somewhere to live
Start a 28-day free trial and have your organisation set up in about 10 minutes.