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

I can add/subtract, but multiply/divide gives error

107 1
Showing results for 
Search instead for 
Did you mean: 

Is it a bug? My formula works when I do +1.

But when I do *1 I get all errors:

Screen Shot 2023-01-14 at 12.17.25 PM.png


1 Reply 1

I figured it out. It is kind of a bug, but also my mistake.

The field the formula is referencing contains an IF statement. When that IF statement is true, there's a formula. When the IF statement is false, I had put apostrophe apostrophe ('') in an attempt to leave those cells blank. Back to the field that's throwing all errors, it was interpreting the other field as text, so throwing all the errors. But as for why the addition worked and not the multiplication, that's weird.

Anyway, the solution for that other field was just to have nothing for the false IF statement, like this:

IF({Plantings}>1,{Units} * {Weeks})