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
- Open a doc that contains a table.
- Click an empty line below the table.
- Type a slash and choose Formula.
- Click the formula field and write the Filter formula.
- Click outside the editor to finish the formula.
Interactive 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
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.
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.
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.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to Filter Data in CodaLearn how to filter data in Coda tables step by step, from opening the Options menu to adding multiple filter rules for precise views.
How to Create Basic Formulas in CodaLearn how to create basic formulas in Coda tables using the formula editor, column references, and operators for automatic calculations.
How to Create a Table in CodaLearn how to create a table in Coda using the slash command or plus button, then customize columns and rows for your data.
How to Use the Gmail Pack in CodaAdd the Gmail Pack to a Coda doc from the Packs list in the insert panel, try it for free, and see its tables, buttons, and formulas for email.
How to Use the Google Calendar Pack in CodaAdd the Google Calendar Pack to a Coda doc from the Packs list in the insert panel, try it for free, and see the tables, buttons, and formulas it adds.
How to Use the Slack Pack in CodaAdd the Slack Pack to a Coda doc from the insert menu, try it for free, and browse its tables, buttons, cards, and formulas for Slack workflows.
Create interactive demos like this one — free, no coding required.
Start for free →