Coda Prep Doc

Learn by watching

Learn by doing

Relevant reading

Coda Prep Doc

Google Docs and office 365

Explore

Learn by watching

Formula essentials

Coda has a powerful formula language to help you build whatever you want. While the language is similar to what you’ve used in Excel, there are a few differentiators that make formulas easier to write and understand.

And if you’ve never used formulas before, don’t worry! Coda’s formula language is more accessible than you think. With our Formula Essentials video series, we’ll unpack the seven formulas that will benefit every Coda maker, whether you're leveling up your to-do list or building the perfect tool for your team.

Introduction

Knowing just a few formulas will take you a long way.

⁠

Loading…⁠

⁠

Filter formula

When you want to look at just one part of your dataset, use Filter formula.

⁠

Loading…⁠

⁠

User formula

Create personalized user experiences in your doc with User formula.

⁠

Loading…⁠

⁠

thisRow formula

Extrapolate and summarize your data with thisRow formula. Think of it like Coda's alternative to Excel battleship coordinates.

⁠

Loading…⁠

⁠

Contains formula

Extract the information you need with Contains formula.

⁠

Loading…⁠

⁠

Concatenate formula

Concatenate is a formula that strings information together and shows you how to create dynamic subject lines, buttons, and messages.

⁠

Loading…⁠

⁠

If & SwitchIf formulas

Get results based on a certain set of criteria with If and SwitchIf formulas.

⁠

Loading…⁠

⁠

FormulaMap

Apply the same action to a list of items in a table with FormulaMap.

⁠

Loading…⁠

⁠

Check your progress.

Here’s a view of your learning plan. What do you want to accomplish next?

Task

Time commitment

Status

Watch the

Coda essentials

⁠

videos.

80 mins

Not Started

Subscribe to the Coda webinar channel at

crowdcast.io/coda-hq

⁠

1 min

Not Started

Bookmark the links in

Relevant reading

⁠

1 min

Not Started

Begin

Exercises

⁠

Not Started

No results from filter

1 hr 22 mins

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.