Cell Formula not Column Formula. Help

#1

I have a table, but how do I enter a formula on an individual cel, whenever I do = it automatically sets the formula to the whole column and I just need the formula for that cell. Any help is appreciated.

#2

Formulas apply to all rows for that particular column - this is one of the big differentiators between a spreadsheet and a table-based system like Coda (although Excel does allow you to specify formulae for entire columns when cells are converted to a table).

Can you explain your use case? I.e. why do you want a specific formula on a specific row?

Bear in mind that formulas can reference other columns in the row (and other tables) so you can, for example, have a formula that does different things on different rows.

1 Like
#3

Ok got it. I just wanted to import values to different cells. For example:

A1- Name1 B1 Imported Value from other place
A2- Name2 B2 Imported Value from other place

But I get it, I might have to change the way im putting it on the table

#4

Here’s an example. The “Name” column at the end is constructed automatically based on other values in the row.

1 Like
#5

Pretty complex formula but yeah I get what you are saying. The last cell detects if the first cell is changed and get information automatically.

1 Like
#6

There’s quite a lot of it but it’s actually quite simple because it only uses data in the same row. Formulas can work with any data from any row (or calculated aggregates of rows) in any table or tables. You have ultimate flexibility to do what you want, and once you get used to the way it works it’s actually pretty easy to use.

4 Likes
#7

I cant see this formula. Would you mind sharing?

#8

hi,

First you have to copy the document. button in the top right corner.

#9

I’ve already done that. When it opens, it’s on read only mode. I can’t edit the column and as a result, view the formula the column has.

#10

Check again, please. Below screenshots

#11

@Przemek_Sawicki, Justin_VanDervort is correct, you’re base isn’t shared properly.

When it’s opened, before we even copying the base, all we can see are your folders and sections but no data. Nothing, no graphs, not text, nothing.

EDIT: I take that back. It’s working. I didn’t drill down to pricing before making my post.

#12

Same Issue

I also have this issue, but I don’t think the workarounds cover the fact that sometimes you just want a specific cell to be calculated.

Example

For instance I’m putting together a matrix for some SaaS services. I have a Currency cell, Est. Annual Cost, and for the most part I just enter a number. In one cell, I’d like to just be able to type =[Users].count()*12*73 … That’s X users for 12 months at $73 per head. In other words, it’s just a quick calculation. Other services (rows) might have a different calculation method, or just a raw number, so I definitely don’t want it to apply to the whole column.

Yes, I could just punch it into a calculator – I don’t really have to count rows in the Users table. But when going back to look at the number, it’s really helpful to see the formula and know how I came up with the total.


Feature Request

I don’t know what you call the = that fundamentally changes how a cell is handled, so I’m using the term “CalcKey”.

Can we just have an additional CalcKey, like perhaps a == (double equals) that then allows one-off formulas?

I know Coda isn’t Excel, and I don’t expect it to be. But it is a giant calculator, and I’d like to be able to use it that way sometimes.