Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 20, 2022 12:17 PM
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
Solved! Go to Solution.
Dec 20, 2022 10:07 PM
That formula looks fine. What's wrong with it? Could you provide some screenshots?
Dec 20, 2022 10:07 PM
That formula looks fine. What's wrong with it? Could you provide some screenshots?
Dec 21, 2022 05:21 AM
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:
Dec 21, 2022 06:04 AM
Adam,
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.
Dec 21, 2022 06:09 AM
Hi I tried this equation and unfortunately it did the same thing I am experiencing with my equation.
Dec 21, 2022 06:58 AM
Oh, because it’s not empty, it’s 0.
IF({ODO Miles}>0, {ODO Miles}, {Odo Calculation}).
Jan 11, 2023 07:58 AM
Strange but the formula ended up working a few days later with no changes. Must of been a glitch