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

# If Statement

Solved
167 6
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hey Everyone,  Needing help with another if statement.  It is not behaving in the manner I am expecting.

I have 3 fields Odo calculated (Formula Field), Odo miles (Number field) and Final Odometer (If statement).  I am trying to have the Final odometer field populate with the odometer calculated field if the odometer overwrite field is empty.  If the Odometer Overwrite field is not empty I want that number to populate in the Final Odometer field.

I currently have

IF({ODO Miles} = " ",
{ODO Miles}, {Odo Calculated})
1 Solution

Accepted Solutions
13 - Mars

That formula looks fine.  What's wrong with it?  Could you provide some screenshots?

6 Replies 6
13 - Mars

That formula looks fine.  What's wrong with it?  Could you provide some screenshots?

7 - App Architect

ODO Miles = Odometer Overwrite, yes? If so, then what you currently have -  IF({ODO Miles} = " "{ODO Miles}, {Odo Calculated}) - says “if the overwrite is empty, use the overwrite, otherwise use the calculation.”

What I think you want is the opposite:

IF({ODO Miles} = " ", {Odo Calculated}{ODO Miles})
or
IF({ODO Miles}, {ODO Miles}, {Odo Calculated}).
5 - Automation Enthusiast

Please see a screenshot.  As you can see the calculation field Odo calculated shows since the Odo Miles is empty but where the odo miles is empty.

5 - Automation Enthusiast

Hi I tried this equation and unfortunately it did the same thing I am experiencing with my equation.

7 - App Architect

Oh, because it’s not empty, it’s 0.

IF({ODO Miles}>0, {ODO Miles}, {Odo Calculation}).

5 - Automation Enthusiast

Strange but the formula ended up working a few days later with no changes.  Must of been a glitch