Using SUM function?

Hi @Romero_Mckay,

Re the “Values can’t be directly edited” message, if you think of it in terms of an Excel spreadsheet, where say you had a column of running totals that you have locked, this is the kind of message that might be displayed to a user that tries to edit that locked column. The message in Coda is simply to let the end user know that it is a calculated column and can’t be edited - it is not some sign of a deficiency in the software.

In terms of your broader question, as others have said, Coda is not a spreadsheet so it simply doesn’t work to look for it to function as Excel does. There are many ways to achieve the kind of data you are ultimately after - and that I believe is the starting point for thinking about it - what data do you need - then look at how Coda can do that, rather than thinking about how you think it should be done just because that’s how you would do it in another, very different tool.

Coda’s utility, and therefore its power, if phenomenal, and you don’t need “extreme lengths” to achieve it, but you do need knowledge of the tool, just as a new user to Excel would need. Sure, some things that you can do in Excel may not be native to Coda, and may need specific solutions to achieve, but the reverse holds true as well.

If you can answer that question of what you are actually after, and provide a sample doc, then there are many people here who will willingly help and point you in a direction and/or provide you with examples of how to achieve it.

This is pretty straight forward to do, the only difference is the calculations would be done on the canvas below the table, rather than in a cell in the table.

Simply typing “=” on the canvas below the table will open the formula editor from which you can directly reference any table in your doc. You can use the Filter() formula and the various logic formulas to select specific data from a table to perform calculations on. You can name any canvas formula so the result of the formula can be used in other formulas.

Hopefully that helps.