How to Use the ThisRow Formula in Coda

Learn how to use the ThisRow formula in Coda to add a column formula that reads values from the same row, so each row shows its own result.

Quick answer

To use ThisRow in Coda, open the menu on a column header, choose Add formula, and write a formula that starts with thisRow followed by a column name. Coda applies it to every row in that column, and each row reads the value from its own row, such as the name in column one.

Steps at a glance

  1. Open a table with a column to fill.
  2. Open the column menu from the header.
  3. Choose Add formula.
  4. Type a formula that starts with thisRow.
  5. Save the column formula.

Interactive demo

Loading demo…

Summary

ThisRow lets a column formula refer to other columns in the same row. Instead of writing one formula per row, you write it once and Coda evaluates it for each row.

Step-by-step guide

  1. Step 1

    Open the column menu

    Open the table and hover over the header of the column you want to fill. Click the arrow in the header to open the column menu.

  2. Step 2

    Choose Add formula

    In the column menu, choose Add formula. A Column formula panel opens so you can write a formula for the whole column.

  3. Step 3

    Save the column formula

    Start the formula with thisRow and pick one of the table's columns from the list that appears. The panel previews the value for Row 1 of 3. Click the formula button to save it and fill the column.

Why this matters

You need a column that repeats or combines what each row already holds, such as a task name. Writing one ThisRow formula fills the whole column at once, and it stays correct when you add more rows later.

Frequently asked questions

  • Why does the preview show only one row?

    The panel previews the formula against one row at a time, labeled Row 1 of 3 in this table. Saving applies it to every row.

  • Can I use ThisRow on a Free plan?

    Yes. This was done in a Free plan workspace.

Create interactive demos like this one — free, no coding required.

Start for free →