Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Can I do simple math?

125 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

In Google Sheets, I do this in a cell:


...and the answer is output in the cell.

Can I do that in AirTable? To be clear, I want to have different formulas in each cell, not one formula for the whole column.

3 Replies 3

Hi @philraymond ,

It will be one formula per column always.  This is a good thing as it takes away the Sheets chaos...

Now to do math like above, you just create column A with free number input, column B with free number input and column C with fixed formula A * B.

If that math is not sufficient you create additional field D "Calculation type" - with single select containing "Add", "Substract" or "Multiply by 3 and deduct 1"  and then you upgrade the formula in column C to something like:

SWITCH("Calculation type",
"Add", A+B,
"Substract", A-B,
"Multiply by 3 and deduct 1", (A+B)*3-1

I hope that helps!

No you cannot do this in Airtable. One of the differences between a spreadsheet and a database is that each editable cell value should be an “atomic” value, the smallest piece of meaningful data. When you have an expression like 1+1, you have multiple bits of meaningful data that you want to combine. If you find yourself wanting to do this often, you might want to revisit your base design. 

Both helpful answers, thanks very much.