CONFIGURE COLUMNS
Column data types
Choose a data type so each column displays its values correctly. The selector offers Text, Number, Date, Boolean and Enum.
Choose a type
Edit the Simple Table macro, open Columns, select a column and choose Data type under Display. The settings shown beneath the selector depend on the type you choose.
The five types
Each type offers formats and settings suited to its values. Choose the one that describes what the values in this column mean.
- TextNames, descriptions, IDs and other values you want to read as text.
- NumberAmounts, quantities and measurements. Format them as decimal, compact, currency or percentage values.
- DateCalendar dates with Confluence, ISO 8601 or custom display formats.
- BooleanTrue/false values such as yes/no or complete/incomplete.
- EnumRepeated categories such as status or priority, with colors and appearance options.
Recognize column types in the header
A small icon beside each column name identifies its configured type: Text, Number, Date, Boolean or Enum. The same type symbols appear in the column type selector. Sorting and grouping use separate controls.
- Text
- Number
- Date
- Boolean
- Enum
In the macro settings, open Display and use Show column type icons to show or hide them, then save the macro. Icons are enabled by default for new tables. Existing tables keep their saved setting; you can enable the option for them here.
Row numbers and the parent headings in a pivot table do not receive a type icon. Changing this option changes the appearance, not the column type or its values.