Editing Formulas

Best practices on editing and writing your formulas

Whenever you open the normal formula-editor in Coda, it defaults to a small window in which you can edit your formulas as shown on the right.

For the majority of the formulas you write, this small window will suffice. But as you grow in your Coda Expertise the formulas you write will become longer and longer.

⁠

As you find yourself writing longer formulas there are two things about the formula editor that will be your friend:

Expanded formula editor

Auto-format

Expanded Formula Editor

To access the expanded formula editor, hit the expand arrows in the screenshot below

⁠

⁠

Auto-format

Long formulas can become unwieldy and hard to read. Formatted formulas are both easier to read and therefore easier to de-bug and fix. Auto format your formulas using the Auto-format button as shown in the screenshot below

⁠

⁠

Press this auto-format button and turn your formulas into this →

⁠

⁠

Want more thorough educational content like this? Join the Coda School today!

⁠

Coda School Take your Coda formulas from "I can get by" to "I can do anything" with a fully interactive course designed to be taken at your own pace, with accountability and community built in. www.codaschool.io⁠

Gallery

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.