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
- Open a table with a column to fill.
- Open the column menu from the header.
- Choose Add formula.
- Type a formula that starts with thisRow.
- Save the column formula.
Interactive 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
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.
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.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to Create Basic Formulas in CodaLearn how to create basic formulas in Coda tables using the formula editor, column references, and operators for automatic calculations.
How to Add Columns to a Coda TableLearn how to add, rename, and configure new columns in a Coda table using the built-in plus button and column type menu.
How to Add Comments in CodaLearn how to highlight content, leave comments, and @mention teammates in Coda to collaborate and keep feedback organized in your doc.
How to Add Pages in CodaLearn how to add, place, and organize pages and subpages in Coda using the page list panel, right-click menu, and New Page button.
How to Add Rows to a Coda TableLearn how to add rows to a Coda table using the plus icon, keyboard shortcuts, or right-click menu for precise row placement.
How to Assign Tasks in CodaLearn how to assign tasks in Coda using Person-type columns, filters, and sharing settings so every team member sees exactly what they own.
Create interactive demos like this one — free, no coding required.
Start for free →