Launched: Calculate column

Today, we’re introducing a time-saving new column type: calculate. Calculate lets you populate a column with a formula using a structured builder based on other columns in the table or row properties. You can perform common column calculations like date, text, percentages, and more with just a couple clicks; the column type will automatically match the result type of the calculation.

column options

Calculate builds on the simplification improvements we’ve made with linked relations, compose, and the /summarize table command to create powerful workflows in Coda without spending time writing and debugging formulas.

Even with this addition, your existing formula-based workflows will still be usable. You can also always toggle between the calculate structured builder and the formula builder through the column options dialog or write formulas directly when creating columns by typing =.

Additionally, we’ve made some updates to the column options menu, which will now be consistent across column types that dynamically fill values for each row (including calculate, compose, and AI). This secondary tab can also be used to configure and update existing sources that populate the column. We hope this added consistency helps provide you with a repeatable workflow when configuring a column.

column options

We’re excited to see how calculate will make the Coda experience smoother for you and your collaborators! Try it out and let us know if there’s any other frequently used formulas you’d like to see added as a calculation — we’ll be making rolling updates to support additional calculations.


I love how you guys are really pumping out the new features and improvements.

I do feel like the last few have been geared more towards simplification of existing functionality. I assume this is what your user research shows as a need. However, I was wondering how you are expanding functionality for more of the power users?


p.s. I love your product!


Huge update! Takes the power of coda to regular non advanced users!! Great work!!

1 Like

Yes, while we’re currently focusing on simplifying parts of the product, we’re still committed to increasing the power of what our deepest users can do with Coda, especially when it comes to connecting Coda to other tools and building custom workflows. We’ll soon be launching 2-way sync capabilities for many major Coda packs and enabling Pack makers in our ecosystem to do the same. We’ll also be expanding the limits of Coda page embeds, working towards allowing seamless embedding of a page and all it’s subpages.


@Kelly_Lynn the two videos currently show the same content. Is is possible that you wanted to show more details in the second video?


WOW, thank you guys for all of your hard work!


Thanks Kariem! The first gif now shows the steps of building a calculation.

1 Like

More FIYAH from the Coda Team - PROPS!



The final part of the first GIF goes by so quickly I can’t really see what the output is. Is the new feature documented with still images somewhere?

I hate this change. For power users who need to view, create, and edit formulas quickly this is hugely inefficient and now I can’t quickly access the formula area without several clicks and navigation.

I’m afraid you missed the Edit calculation button, but it’s still faster to just click the column and write an equal sign (shift + 0)! :slight_smile:



Nothing prevents you from using the existing functionality.

Hi! For power users the fastest way to use custom column formulas is still to press = on a selected column.

1 Like

Thanks for this new features. it makes a lot of sense to me.

It looks like the word “Calculate” is used a lot. There is a “Calculate” column type to pick when creating a column. One of the “Calculate From” choices is “Calculate”. That is a lot of use of the word “calculate”. I wish that there were a little bit different vocabulary thrown in there to differentiate between these three different levels where the word “calculate” appears. Maybe toss in the words “generate” or “compute/computed” into the mix?

For the “Calculate From … column” choice, will you eventually have chaining of operations or allowing multi-select, such as trimming a column value and converting it to lower case? Or do you expect people to user a formula for those use cases?

I found the name of the tab “Calculate” changing to “Fill Values” when I clicked the “Settings” tab to be disorienting.

For the “Fill values” choices, I would like to see “Formula” as a top level choice separate from the choices for column/row properties, along with “Calculate”, “Compose”, and “AI”. I like to use formulas and feel that they are distinct enough from column/row properties.

I wish that I could use formulas inside a “Compose” type. That’s a totally different ask. Just throwing it out there. For now, I will use either a formula with a text column, or I will create helper columns.

1 Like

Thanks for the feedback Kuovonne! Really helpful as we work to make more improvements here!

One tip on your last point: within a Compose column you should be able to press equals to create a formula within the Compose content already, but let us know if there’s something else you’re looking for there!

1 Like

Hey Paul, we have several stills here in our help article: Calculate column values | Coda Help Center

1 Like

Thank you for mentioning this! I was also having a rough time with the formula being so many clicks away, but I never knew about the = shortcut!


Awesome! Works great. I was using the @ to include stuff based on what I saw in the UI, so I never tried =. Sounds like = works in way more places than some of us thought!

1 Like

Oh thank goodness. I’ll try that.

1 Like

This looks like another great new feature! At first glance, it’s not altogether intuitive, however and a sample doc and/or webinar would be useful. :slightly_smiling_face: