# Master Coda's Filter Formula!

> Learn how to master Coda's Filter formula for tables, views, and dashboards. From basic filter bars to advanced Filter() formulas with practical examples.

Author: Scott Weir  
Published: 2023-07-20  
Last updated: 2026-02-24  
Tags: Coda 101 Tutorials  

## What does Filter even mean?

Filtering a table or view is comparable to "looking at a restaurant menu and deciding you actually only want dessert so you flip to the back and focus on those items." In Coda, users request: "take this table and only show me the items that match a certain set of criteria."

The example table contains information about people's ages and heights.

## Anyone can filter using the Filter Bar

Coda offers a user-friendly filtering option. Users can click "Options" > "Filter" when hovering over a table. Toggling "Enable filter bar" allows anyone to filter without changing others' views. Users can select which columns are filterable.

## You choose the filter for someone else

Users can create pre-filtered views for specific audiences. This prevents the need for constant manual filtering when recipients only need particular information subsets.

## Coda's Filter() formula

The Filter() formula enables advanced functionality including table connections, dashboard creation, and data insights. It comprises three main parts:

1. The table to filter
2. Criteria defining which rows to return
3. The desired column (optional)

### Basic Example

A simple formula filters the People table: "filter for anyone whose name is 'John.'"

### Intermediate Example

A more complex formula states: "look into my Expenses table and find only rows where the month matches this row's month and the year was 2022. Then return the average of those amounts."

## More Resources

Users seeking mastery should explore The Coda School, which teaches data-types, Boolean operators, and list principles in depth.


---
Source: https://simpladocs.com/blog/coda-filter-formula-tutorial