Skip to main content

Tables

Covers adding a Table element to an SOP page, the spreadsheet grid, adding and deleting rows and columns, column types and the column menu, Status labels, Person cells, keyboard shortcuts and fill down, and what you can change outside Edit.

Written by Support

šŸ“‹ Overview

Some company information is a list that keeps changing. Which trucks are due for service. Who holds which certification and when it expires. Which suppliers you use for what. Kept in a spreadsheet on one laptop, the list is out of date the day someone else needs it.

A Table element on an SOP page in Company Operations keeps that list where your team can see and update it. It works like a spreadsheet: click a cell and type, move around with the keyboard, and drag a value down a column. You set up the columns in the page's Edit mode, and your team adds and updates rows.


šŸ” Understanding Tables

⚔ What It Does

Tables allow you and your team to:

  • Keep a live list on an SOP page -- next to the process it supports

  • Work like a spreadsheet -- type in cells, use keyboard shortcuts and fill values down a column

  • Choose from 12 column types -- including Person, Date, Status, Priority, Link and Currency

  • Track progress with Status -- Not Started, In Progress, Stuck and Done, with your own labels

  • Sort and reorder -- sort by a column and drag columns and rows into order

  • Let your team add rows -- without opening Edit

  • Keep data private -- with Enable privacy?

šŸ“… When to Use It

Tables are most valuable when you want to:

  • Track equipment, vehicles or tools and their service dates

  • Keep a list of certifications and expiry dates

  • Maintain a supplier or contact list for a process

  • Track a short list of company tasks with a status


šŸ“ Step-by-Step Instructions

1. Add a Table Element

  1. Open the SOP page and click Edit. On an empty page, click New Element straight away.

  2. Click New Element and choose New Table

  3. Enter the Table Title and, if you like, a Table Description

  4. Tick Enable privacy? if members should only see their own data

  5. Click New

  6. Click Save (top right) to save the page

The table starts with three columns, Name, Status and Date, and one empty row.


2. Set Up Columns

Columns change only in the page's Edit mode.

  1. Open the page and click Edit

  2. To add a column, click the orange + at the end of the column headers. It adds a Text column named "Column" and a number.

  3. To change a column, click the three dots on its header:

    • Rename -- type the new name in the header and press Enter

    • Change type -- choose Text, Number, Currency, Status, Dropdown, Priority, Person, Date, Email, Phone, Link or Checkbox

    • Sort ascending, Sort descending and Clear sort

    • Delete column

  4. To move a column, drag it by the handle on its header. To move a row, drag it by the handle at its left.

  5. Click Save (top right)

Important: Delete column removes the column and its values at once, with no confirmation. Check before you delete.


3. Add Rows and Fill In Cells

  1. Click + New row under the table

  2. Click a cell and type, or double-click it to open its editor. A Status cell starts at Not Started. A Person cell opens a list of your company's users with Search person....

  3. Press Enter or Tab to move on

You don't need Edit to add rows. Rows you add outside Edit are saved straight away.

To delete a row, hover over it and click the x at its right end (Delete row). The row is removed at once, with no confirmation.


4. Use Keyboard Shortcuts and Fill Down

Click Shortcuts above the table to see them all. The main ones:

  • Arrow keys move between cells. Tab and Shift + Tab move across columns.

  • Enter or F2 opens the editor on a cell.

  • Escape cancels an edit. Delete or Backspace clears a cell.

  • Ctrl + Z undoes and Ctrl + Shift + Z or Ctrl + Y redoes (⌘ on a Mac)

To copy a value down a column, click the cell, then drag the orange dot at its bottom-right corner down or up.


5. Change Status Labels

The Status column starts with Not Started, In Progress, Stuck and Done. To change them:

  1. In Edit, open a Status cell and click Edit labels

  2. Change a label's color or name, delete it with its trash icon, or click + New label to add one

  3. Click Apply, then Save (top right)


6. Know Who Can Change What

  • In Edit (Full Access on Standard Operating Procedures): change columns, every row and the row order

  • Outside Edit (Collaborate or Full Access): add rows and change the rows you added

  • View Only: see the table but not change it

With Enable privacy? on, members see only the rows they added. Owners and admins still see every row.


⭐ Best Practices

  • Set up columns before your team starts -- columns only change in Edit, so give the table the columns it needs first.

  • Pick the right column type -- a Date column always holds a real date. A date typed into Text can be written any way.

  • Use Status for anything with a stage -- a status pill is faster to scan than a written note.

  • Rename the starting columns -- Name, Status and Date are placeholders. Name them for what they hold.

  • Use fill down for repeated values -- drag the orange dot instead of typing the same value in every row.

  • Keep one table per list -- mixing trucks and certifications in one table makes both hard to use.


ā“ Common Questions

Q: Do I need to click Edit to change a table?

A: Not to add rows. Anyone with Collaborate or Full Access can add rows and change the rows they added without Edit. To change columns, other people's rows or the row order, click Edit on the page.


Q: Why can't I change a row?

A: Outside Edit, you can only change rows you added. Someone with Full Access on Standard Operating Procedures can change any row in Edit.


Q: Why is my new column called "Column 4"?

A: The + button adds a Text column with a numbered name. Click the three dots on its header and choose Rename and Change type.


Q: Can I change the Status options?

A: Yes. In Edit, open a Status cell and click Edit labels. Rename, recolor, delete or add labels, then click Apply and Save.


Q: What does Enable privacy do on a table?

A: Members see only the rows they added. Owners and admins still see every row.


Q: Is a Table the same as a Form?

A: No. A Form collects new entries one at a time and records who added each one. A Table is a list your team keeps up to date by editing cells. See Custom Forms.


āš ļø Common Mistakes to Avoid

āŒ Don't

āœ… Do

Type dates and amounts into Text columns

Use Date and Currency columns

Delete a column to clear a few cells

Clear the cells with Delete or Backspace

Expect your team to add columns

Set up columns in Edit before they start

Leave the starting columns with their default names

Rename them for what they hold

Forget to save after changing columns

Click Save (top right) before you leave Edit

Did this answer your question?