Explore

$icon picker$
A fistful of formulas: The 5 you need to know
A fistful of formulas: The 5 you need to know

You only need to learn a few to see a big result.

You only need to learn a few to see a big result.

Maria Marquis

When I first started at Coda, I heard the formula language was incredibly powerful and that it helped turned docs into apps. Because I love a good challenge, I headed to

coda.io/formulas⁠

and started scrolling....and scrolling...and scrolling. There were TONs of formula components available. I started to feel a bit disheartened.

Fast forward to today. Am I a master of every formula on that page? Heck no. Is it because Coda is smarter than me? Well, maybe a little, but mostly because I learned a secret. To get what I need from 95% of my docs, I only need 5 formulas.

Filter

If I could only have one Coda formula, it would be Filter(). Filter formulas are a great way to customize your table, whether you're creating a new view in a different section or refining the data in your original table. Filter helps you look at just a portion of your data to answer questions like “How many of these tasks are urgent?” and “Which of these books did Erin rate 5 stars?”

The basic structure of filter is:

[Table you want to look at].Filter[Part of the table you’re interested in].[What you want Coda to do]

Or:

⁠

Screen Shot 2020-09-28 at 3.09.24 PM.png

⁠

In the formula above, we want to look at the table of blog posts, see the posts where the category is “Launch,” and know how many of those posts there are.

You can be as involved with the filter portion as you like. You’re not tied to a simple equals. You can use AND, OR, <, >, true, false, and any combination of these.

User

People are an important part of Coda—after all, we can’t get everything done by ourselves. Since folks log in to work with you in Coda, you can use the User() formula to create a customized experience. By typing =User() into Coda, your doc will automatically display the name of the person logged in looking at the doc. For example:

Welcome to my doc,

@Anonymous User

⁠

. Have a lovely day!

Beyond using this formula for custom greetings, you can use it to:

Automatically assign tasks to whoever clicks a button.

Combine it with filter to create a dynamic “My Tasks” view that automatically filters the tasks to whoever is logged in.

thisRow

If you’ve used a spreadsheet before, you know that formulas usually name a place in a grid, like A6+B123. Coda’s formula language takes a different approach.

In Coda, the smallest unit is the row. Think of it this way: That task isn’t just the name of the task. You also want to know who owns it, when it’s due, how long it will take, and more. A row is comprised of all of these data points!

Because rows always travel together, you can use the thisRow formula component to do a few things. And you can use a . to show more of the context. In the table below, I’m using the . to show me who is the project lead.

⁠

Screen Shot 2020-09-28 at 4.44.50 PM.png

⁠

You can also use thisRow to summarize information across your tables. In the table below I’m showing the number of tasks for each person on the team.

⁠

Screen Shot 2020-09-28 at 4.45.55 PM.png

⁠

Contains and Matches

Contains and Matches are the formula components that let you map tables to controls like dropdown menus.

You’ll use Matches if you have a single select list or a date range. In this example, I want to know how many blog posts were published in May.

⁠

Screen Shot 2020-09-28 at 4.51.52 PM.png

⁠

You’ll use Contains for everything else. This makes sure that if your criteria is included, even in a multi-select list, you’ll be covered.

⁠

Screen Shot 2020-09-28 at 4.53.22 PM.png

⁠

When in doubt, use Contains!

If and SwitchIf

The last formula components that I use all the time are If and SwitchIf. These let me build responsive results based on my choices. You’ll use If in an either/or situation and you’ll use SwitchIf if there are multiple options.

Let’s start with If:

If(condition, What you want to happen if that condition is true, What you want to happen if it’s false)

In this example, if the Out Of Office is not blank, then I want to show their manager’s email as the contact.

⁠

Screen Shot 2020-09-28 at 5.01.17 PM.png

⁠

SwitchIf is the same, except that you can include as many options as you like:

SwitchIf(Condition 1, Result if that is true, Condition 2, Result if that is true....)

In this example, I have a different person assigned based on the status of the project.

⁠

Screen Shot 2020-09-28 at 5.01.41 PM.png

⁠

Now what?

Focus on trying these formulas, and see how your docs soar. If you ever need help, don’t hesitate to get in touch. You might also want to check out our formula fitness webinars for a few deep dives. You’ve got this!

⁠

How to use filters in Coda | Coda Formula Fitness Get a copy of the doc here - https://coda.io/@maria-marquis/formula-fitness-level-up-your-filters youtu.be⁠

⁠

Using user & time formulas in Coda | Coda Formula Fitness Ever want to get better at your Coda formula skills? We do too! That's why we've decided to bring our formula fitness exercises to all of you. Join Maria for a deep dive into the user and time formulas that allow you to customize docs and build them for growth. You'll even get an exercise doc to take with you. youtu.be⁠

⁠

Using the Contains, Matches, & Find functions in Coda | Coda Formula Fitness Ever want to get better at your Coda formula skills? We do too! That's why we've decided to bring our formula fitness exercises to all of you. Join Maria and Solutions Architect, Al, for a deep dive into all the ways to connect your data. You'll even get an exercise doc to take with you. youtu.be⁠

⁠

How to use If & SwitchIf formulas in Coda | Formula Essentials Welcome to Formula Essentials. In this video, Maria introduces you to If, your go-to if-then formula, and the more sophisticated SwitchIf. Topics covered: Using If for an out-of-office calendar Using SwitchIf for hand offs Visit coda.io/learn to hone these skills and more. Coda is a new doc that brings words, data, and teams together. It starts with a blinking cursor on a blank page and can grow as big as your team's ambition. Coda comes with a set of building blocksーlike pages for infinite depth, tables that talk to each other, and buttons that take action inside or outside your docーwhich anyone can combine to make a doc as powerful as an app. People have made Coda docs that do everything from launch products, to scale small businesses, to help them study for tests. What will you Coda? Socialize with us: linkedin.com/company/codainc/ twitter.com/coda_hq crowdcast.io/coda-hq youtu.be⁠

⁠

What is thisRow formula & how to use it in Coda | Formula Essentials Welcome to Formula Essentials. In this video, Maria introduces you to thisRow, which will help you extrapolate and summarize your data. Think of it like Coda's alternative to Excel battleship coordinates. Topics covered: Extrapolating Summarizing Visit coda.io/learn to hone these skills and more. Coda is a new doc that brings words, data, and teams together. It starts with a blinking cursor on a blank page and can grow as big as your team's ambition. Coda comes with a set of building blocksーlike pages for infinite depth, tables that talk to each other, and buttons that take action inside or outside your docーwhich anyone can combine to make a doc as powerful as an app. People have made Coda docs that do everything from launch products, to scale small businesses, to help them study for tests. What will you Coda? Socialize with us: linkedin.com/company/codainc/ twitter.com/coda_hq crowdcast.io/coda-hq youtu.be⁠