Data and calculations

Create a data table

A data table is a spreadsheet inside the board: it stores values and formulas. A plain table is for static text, lists and comparisons without calculations. Choose the right type before you enter a budget or a task tracker.

1. Open Insert, search for Data table and insert it.

2. Give it a unique name, for example Budget. That name lets other formulas refer to it.
3. Enter headers and values. Select a cell to edit it, or a range to act on several cells.
4. Type a formula that starts with =. If B2 contains quantity and C2 unit price, enter =B2*C2 in D2.
5. Review the expression in the formula bar and use autocomplete. Extend it to other rows with the fill handle.

6. Apply number, currency, percentage or date formatting where appropriate.