List view
What a list view shows
Section titled “What a list view shows”A list view shows items as rows and fields as columns. Items that live inside other items appear as an indented tree.
Choose the columns
Section titled “Choose the columns”The gear button at the end of the header row opens the column list. Tick a column to show it, and drag to reorder.
Drag a column header to the left of Title to show that column before the title. Freeze up to Title, under Behaviors in the toolbar’s Layout panel, keeps every column up to and including Title in place while you scroll sideways. The freeze is yours alone.
Drag the right edge of a column header to change its width. Column widths are yours alone too. To return a column to its default width, choose Autosize column in the header’s ⋯ menu, or Autosize all columns for every column.
WBS is one of the columns you can tick. It shows the outline number of the item, such as 1.2.3. The top-level items of the view are 1, 2 and 3, and their children are 1.1, 1.2 and so on.
A filter can skip numbers, and sorting or collapsing rows never changes them. The same item can have a different number in another view. A person whose role hides some item types can see different numbers for the same item.
Predecessors and Successors are columns you can tick. They show the links of each item, such as 1.4FS+2, and you can type in them. Gantt view explains what to type.
Total float is one of the columns you can tick. It shows how many working days an item can finish later before its plan finishes later. A dash means float cannot be worked out, such as for an item with no dates. How dependency scheduling works explains how float is counted.
Time in a field, such as Time in Status, is one of the columns you can tick. The column list offers it right after its field. The column shows how long the item has held its current value. Sort it ascending to put the most recent change first. How time in a status is measured explains why a long time shows in amber or red.
Add a field from the column list
Section titled “Add a field from the column list”Select New field at the bottom of the column list to make a field without leaving the view. When you have typed a search that no column matches exactly, the button offers to create a field with that name instead.
- Type the field’s name and pick its type.
- Under Applies to, keep or narrow the types. When the view shows only some types, the field can apply only to those.
- Select Create, or press
Enter. The column list closes and the table scrolls to the new column.Esccloses the form and keeps the column list open.
The field exists for the whole organization at once. Its column shows in your own draft, so Save for everyone shares the column, and Discard removes the column but keeps the field. New field appears only when your role may create fields.
A formula stays empty until you write it. A lookup shows the title of the item above until you choose what it looks up. For these, and for an Auto ID or a select field, the message that appears has Set up in Settings, which opens the field in Settings → Fields. The button appears only when your role may edit fields.
Choose a column’s total
Section titled “Choose a column’s total”The total row and the group headers can show a total for a column. To change how a column is totalled, open its header menu and pick a function under Total. A column that cannot be totalled has no Total section.
- A number column offers Sum, Average, Min, Max, Count non-empty and None.
- A date column offers Min, Max, Count non-empty and None.
- A text, select, people, relation or checkbox column offers Count non-empty and None.
- Created on and Updated on have no Total section.
- The function marked (default) is the one a column uses when the view picks none. For a number or date column, it is the field’s Rollup setting, and picking it makes the column follow that setting.
- The tables of a Gantt view and a schedule view have the same menu.
How values roll up to a parent explains how each total is counted.
Group the rows
Section titled “Group the rows”The toolbar’s Layout panel holds Group by, which takes one field or several. Tick Include empty values under Behaviors to also show groups that no item holds yet, such as an unused status or a person with no items. It works once Group by has a field.
When you group by a people field, a deleted user gets no group. An item whose only person in that field is a deleted user goes under Not set.
Set the depth
Section titled “Set the depth”The toolbar’s depth control names the level you read at. Press - and = to step shallower or deeper.
Narrow what you see
Section titled “Narrow what you see”Press / to focus the quick search, and Esc to clear it. Filters live in the toolbar’s Items panel.
A Time in filter, under its field’s history heading, takes a whole number of days. To find stale work, filter Time in Status more than 7 days.
Changes to columns, grouping and sorting stay in your own draft, and so do filters when you may edit the view. A viewer who may edit the view can Save for everyone, and anyone can Discard the draft. A viewer who cannot edit the view keeps their filters as personal filters nobody else sees.
Add, open and move items
Section titled “Add, open and move items”Add an item with the add row at the end of the list, or press C to open the create form. The row reads + Add item, or + Add and the type name when the view allows one type only.
Click a row to open the item. Drag a row onto another item to move it under that item. Esc cancels a drag, and Ctrl+Z undoes the move.
Export the rows
Section titled “Export the rows”Export a view shows where Export is. Export to Excel and Export to CSV both write the visible columns in their configured order, and the rows as drawn. The two files hold the same rows and columns.
The Excel file stores each value as what it is. A date is a date, so the column sorts by date and shows the organization’s date format. A number, a percentage and an amount are numbers, so a column can be summed. The header row stays in view while you scroll.
The CSV file holds text only. The WBS column is written as a formula, such as ="1.10". A spreadsheet then keeps 1.10 as text and does not change it to the number 1.1. The Predecessors and Successors columns are written the same way. In the Excel file these columns are plain text.
A tracked time column is written as hours with two decimal places, under a header that ends in (hours). A Time in column is written as days with two decimal places, under a header that ends in (days).