Part 1: Setting Up Your Table View
Adding and removing columns
Click the Columns tab (the grid icon) on the right side of any table to open the column panel. Columns are organized by category — for example, Project Information, Budget Progress, and Funding Sources. Each category can be expanded or collapsed.
Check a column to add it to your table.
Uncheck a column to hide it.
Use the search field at the top of the panel to find a column by name.
The Columns panel — columns organized by category with checkboxes to show or hide.
Reordering columns
Drag any column header left or right directly in the table to move it to a new position. No settings panel needed.
Resizing columns
Manual — drag the right edge of any column header to adjust its width.
Auto-fit one column — right-click a column header and choose Autosize This Column.
Auto-fit all columns — right-click any column header and choose Autosize All Columns.
Sorting
Click a column header to sort by that column. Click again to reverse the sort direction. You can also right-click a column header and choose Sort Ascending or Sort Descending from the menu.
The column right-click menu — sort, pin, autosize, and column management options.
Pinning columns
Pinning keeps a column fixed in place while you scroll horizontally — useful for keeping a key field like Project name always visible.
Right-click a column header (or click the ⋮ icon).
Select Pin Column.
Choose Left or Right.
To unpin, repeat the same steps and select No Pin.
Grouping rows
Grouping organizes your table rows by a shared field value — for example, grouping projects by Status or Location — collapsing rows into expandable sections with row counts.
To group by a column, right-click the column header and select Group By. To group by multiple columns, right-click additional column headers and add them as further group levels. The table nests groups in the order you add them.
To remove a group, right-click the column header again and deselect Group By.
💡 Not all columns support grouping. If Group By doesn't appear in a column's right-click menu, that column cannot be grouped. This is expected — numeric and calculated fields like Amount Remaining generally cannot be grouped.
💡 Only the first level of grouping saves to a saved view. If you group by multiple columns, only the first group will be preserved when you save — additional levels will need to be reapplied each session.
Filtering rows
There are two ways to filter rows in a table:
Option 1: Column-level inline filter
Click the filter icon that appears on a column header to open an inline filter for that column. Choose a condition from the dropdown:
Contains / Does not contain
Equals / Does not equal
Begins with / Ends with
Blank / Not blank
Type a value in the Filter field below the condition dropdown and the table updates immediately.
Column-level inline filter — condition dropdown open on the Project column.
Column-level inline filter — filter input field with a condition selected.
Option 2: Filters panel
Click the Filters tab on the right side of the table to open the full filter panel. Filters here are organized by column category. Expand any category, find the field you want, and configure it with the same condition options listed above.
Multiple filters can be applied at once — all active conditions must be met for a row to appear.
💡 Some columns are not available for filtering on the projects, documents, and tasks tables. We've prioritized the fields that appear most in saved views. If you need a filter that isn't available, contact support — that feedback helps us prioritize what to add.
Saving a view
Once you've configured your columns, sort, grouping, and filters, save your setup as a named view so you don't have to recreate it each time.
Click Save current view in the Saved Views panel on the right.
Give your view a name.
Choose Private or Public (see below).
Click Save.
The Saved Views panel — Private, Team, and Rabbet view sections with star/favorite icons.
Private vs. Public
Private — only visible to you. Use these for personal working configurations.
Public (Team) — visible to everyone in your organization. Requires the Save and Manage Public Table Views permission, controlled by your company admin.
Favoriting a view
Click the star icon next to any saved view to mark it as your favorite. Your favorited view loads by default when you open that table. Favoriting only affects your experience — it does not change the default for anyone else on your team.
Managing saved views
Saved views are grouped into three sections in the Saved Views panel:
Private — your personal views
Team — public views shared across your organization
Rabbet — default views provided by Rabbet (not editable by users)
To switch views, click the view name. To delete a view, click the trash icon next to it.
Part 2: Viewing Your Information
Collapsing and expanding the side panel
The side panel on the right contains tabs for Saved Views, Columns, Filters, and Export. Click the active tab again to collapse the panel and give yourself more table space. Click any tab to reopen it.
Expanding and collapsing row groups
When rows are grouped, each group header shows the number of rows it contains. Click the arrow next to a group name to expand or collapse it. Groups are collapsed by default when first applied. There is also the condensed row option on the bottom of the toolbar.
Row counts
The total number of rows in your table is shown regardless of how many rows are visible on screen or whether pagination is active. This count updates in real time as you apply filters.
Sticky headers and subtotal footers
Column headers remain visible as you scroll down or to the right — you always know which column you're looking at. On tables with grouped rows, subtotal and total rows are also sticky and stay visible at the bottom of the screen as you scroll through a group.
Exporting your data
Click the Export tab on the right side of the table, or right-click anywhere in the table and select an export option.
Export to CSV
Export to Excel
💡 Exports are limited to 25,000 rows. If your table has more rows than this, you'll be prompted to apply filters to reduce the count before exporting.
Search and filtering
There are two distinct ways to search or narrow your data, depending on where you are:
Search bar (Reports section) — A search bar appears at the top of some reporting tables. This performs a broad search across the visible data in that table.
Column-level filters — Available on all tables via the Filters panel or directly on column headers. These let you build precise, conditional filter fields by field (see Part 1 for full details).
These two tools are independent. The search bar narrows results broadly; column filters give you precise control.
Keyboard navigation
Use your keyboard to move through table cells:
Tab / Shift+Tab — move between cells horizontally
Arrow keys — move between cells in any direction
Part 3. Project Reports
Calculated columns
Calculated columns let you track the metrics your team uses alongside the rest of your project data, instead of in a side spreadsheet someone has to keep updated. Values update automatically as your project data changes.
Create a calculated column
Open Project reports and select the report you want to work in.
Select [Add calculated column].
Enter a name for the column. Use whatever name fits how your team works.
Build your formula using your numeric project fields and simple arithmetic.
Review any guidance or error messages, then save.
Edit or remove a calculated column
Select the column header [or menu].
Choose Edit to change the name or formula, or Remove to delete the column.
Formula guidance
Formulas can use numeric project fields only. Text fields, such as custom text fields or Custom ID, are not available.
Supported operations: addition (+), subtraction (-), multiplication (*), and division (/).
If a formula can’t be calculated, an error message explains what to fix before you save.
Cost analysis
Cost analysis shows how costs compare across your portfolio, so you can spot outliers early and plan your next similar project from real numbers. Categories and Cost Items appear in your report as dollar amounts and as a percentage of the current budget.
Set up Categories and Cost Items on your budget
Cost analysis columns only show values for budget line items that have a Category or Cost Item assigned. If a column is empty, the project’s budget line items likely need to be set up.
Open the project and go to its Budget.
For each budget line item, assign a Category or Cost Item.
Save your changes. The project’s values appear in your report automatically.
To compare projects accurately, use the same Categories and Cost Items across projects in your portfolio.
Read the cost analysis columns
Dollar amount: the total budget assigned to that Category or Cost Item on the project.
Percent of current budget: that amount divided by the project’s current budget, including any approved budget adjustments.
Use the percentage view to compare projects of different sizes side by side.
Inline editing
Inline editing lets you keep project details current across your portfolio in one step, instead of opening each project’s settings every update cycle. Changes save immediately, the same way a spreadsheet works.
Who can edit
You need the Edit project settings user permission to edit fields in a report. If you don’t see the pencil icon, ask your organization’s admin to review your permissions.
Edit a field
Open a project report.
Look for the pencil icon next to a field. The pencil icon means the field can be edited.
Click into the field and type your update.
Option+Return (Mac) or Alt+Return (PC) starts a new line in a TextArea cell
Your change saves immediately.
Enter saves and moves
Tab saves and moves right
Questions? Email help@rabbet.com or use the Send feedback link at the top of any table page.




