How to Use the Filter() Formula in Coda

Use the Filter formula in Coda to pull only the matching rows from a table, add an inline formula under it, and read the filtered result right away.

Quick answer

To use the Filter formula in Coda, click an empty line below your table, type a slash and choose Formula, then write a formula that calls Filter on the table with a condition on one column. Coda previews the matching rows as soon as you finish typing the formula.

Steps at a glance

  1. Open a doc that contains a table.
  2. Click an empty line below the table.
  3. Type a slash and choose Formula.
  4. Click the formula field and write the Filter formula.
  5. Click outside the editor to finish the formula.

Interactive demo

Loading demo…

Summary

The Filter formula returns only the rows of a table that meet a condition you set. It leaves the source table untouched, so you can show a subset of rows anywhere in the doc.

Step-by-step guide

  1. Step 1

    Click an empty line below the table

    Open the doc that holds your table. Click an empty line underneath it so the cursor sits in the page where the formula will go.

  2. Step 2

    Choose Formula

    Type a slash and then the word formula to open the insert menu. Under the Inline heading, choose Formula to add a formula to the page.

  3. Step 3

    Click the formula field

    A formula editor opens with a preview of your table, including its rows and columns. Click the Add formula field so you can start typing.

  4. Step 4

    Click outside to finish the formula

    Write a formula that calls Filter on your table and compares one column to a value, such as the rows whose status is Open. The result appears at the top of the editor as a list of matching rows. Click outside the editor to finish.

Why this matters

You keep every task in one table, but a teammate only needs the ones still open. A Filter formula pulls those rows into the spot where you need them without touching the original table or hiding anything from anyone else.

Frequently asked questions

  • Does the Filter formula change my table?

    No. The formula sits on the page and only reads the table, so the original rows stay as they were.

  • Do I need a paid plan to add a formula?

    No. The formula was added from a Free plan workspace.

Create interactive demos like this one — free, no coding required.

Start for free →