Sheets

A sheet is a spreadsheet whose columns have types, so a date column holds dates and a checkbox column holds checkboxes. A sheet can have several pages, and each page can show its rows as a table, a board or a chart.

Make a sheet

  • On Desk, choose New, then Sheet. Start from a blank sheet or pick a template.
  • To bring in spreadsheets, open Import and drop .xlsx or .csv files. Each file becomes a sheet, and each worksheet in an Excel file becomes a page.
  • Import / Export… in a sheet's File menu brings a file into that sheet. Choose Create new Sheet to leave the sheet as it is, or Add to this Sheet to add the file's worksheets as pages.
  • Ask Pax to make one.

Columns

Every column has a type. Right-click a column's header and choose Configure column to set it.

TypeHolds
TextAny text, such as names and notes.
NumberNumbers, shown with a prefix, suffix and decimal places you choose.
DateA day on the calendar.
SelectA choice from a list of options you set. Multi-select allows several.
CheckboxA box to tick for yes or no.
URLA web address that opens as a link.
TagsYour Blackbear tags, to group rows.
PersonThe people a row is assigned to, such as who owns it.

The same menu renames a column, sorts the rows by it, inserts a column on either side, or deletes it. Double-click a header to rename it in place.

Formulas

Start a cell with = to write a formula. Refer to a cell as A1 and to a range as A1:B5, as in =SUM(B2:B20) or =IF(C2>100, "over", "ok"). To use a cell on another page, put the page's name in single quotes first, as in ='Page 2'!B4. Matching functions show up as you type a name.

To fill a whole column, open Configure column, turn on Formula column and write one expression, such as [Price] * [Qty]. There [Price] is that row's Price, and SUM([Price]) adds up the whole column.

While you type a function, a card under the cell shows its syntax with the argument you're on in bold, what that argument takes, and an example. Insert formula on the bar opens the function browser. Search it by a function's name or by what it does, or pick a group, and choose a function to start a formula with it.

The Formulas reference has every function with an example, how formulas read each column type, and what each error means.

The bar

The bar above the table has undo and redo, the number format, bold and italic, text and fill colors, alignment, Sort by a column and Filter. The number formats are Automatic, Plain text, Number, Integer, Percent, Scientific, Currency, Currency rounded and Accounting.

ActionShortcut
Bold, italicCmd+B, Cmd+I
Undo, redoCmd+Z, Cmd+Shift+Z
Copy, pasteCmd+C, Cmd+V
Select allCmd+A
FindCmd+F
Find and replaceCmd+H
Save a cell and move downEnter
Save a cell and move rightTab
Cancel an editEsc

On Windows and Linux, use Ctrl in place of Cmd. Ctrl+Y also redoes.

Rows, tasks and events

Right-click a row's number, or use its Row actions button, to insert a row above or below, duplicate it, or delete it. Freeze through row keeps that row and the ones above it in view as you scroll.

The same menu turns a row into a task or an event. Create task opens a new task filled in from the row's columns, such as its title, due date, priority and tags. Create event does the same for an event's start, end and location. Once a row has a task or an event, the menu shows Open task or Open event.

Tables, boards and charts

The tabs above the table are saved views. Choose +, pick Table, Chart or Board with the icon beside the name, type a name and choose Save. Right-click a view's tab to rename or delete it.

  • A board shows each row as a card in a lane. In Board settings, Group by picks the column whose values become the lanes. You can also choose the card title, the fields each card shows and the lane width. Drag a card to another lane to change that value. Turn on Show empty lane to see rows with no value in an Uncategorized lane.
  • A chart draws the page as a line, bar or donut chart. Its settings pick the label column and the value columns, with options for grid lines, stacked bars, filled areas and smooth curves.
  • To keep a chart beside the table, choose Add floating chart next to the view tabs. It opens in a small window you can move around. Its chip stays above the table so you can open it again.

Pages

A sheet can hold several pages, like the worksheets in Excel. Add page sits after the page tabs. Right-click a page's tab to rename, duplicate or delete it.

Comments and sharing

  • Right-click a cell and choose Comment to start a thread on it. A folded corner marks the cells that have comments.
  • Share a sheet with a contact to edit it together. Every change is end-to-end encrypted.
  • Version history, in the file menu, lists earlier versions. Open one and choose Restore this version to go back to it.

Excel and CSV

Import / Export…, in the File menu, also saves a sheet as a file.

  • Excel workbook (.xlsx) turns every page into a worksheet.
  • CSV saves the page you're on.

Choose Resolved values to save what the cells show now. Keep compatible formulas keeps the formulas Excel can read, and saves the value of any other formula.

Pax

Pax can read a sheet and change it for you. It adds, moves and deletes rows and columns, fills in cells, and changes a column's type. Ask it to make a sheet from a list you paste in.