Help

Re: Simple IF formula is not updating. Even after I press "SAVE".

545 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl
4 - Data Explorer
4 - Data Explorer

Hi,

I am making what to me seems like a simple change to a simple IF Formula.

 
The prior version of the formula was: 
IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})))

This is the new formula. 

IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})),IF({Debit or Credit},{Debit or Credit}))
 
For some reason, even after I press "SAVE" after updating the formula, when I go out of the field and come back to the field, I see the prior version of the formula. I do NOT get any ERROR messages. 
 
And tried repeatedly to update the formula.
 
I have tried the cache refresh with Com + Shift + R
 
I even closed all AirTable browser windows, and logged out and logged back in to AirTable. No Joy.
 
Any help would be welcome.
 

 

 

2 Replies 2

It’s because you have too many parentheses after the 2nd Money In, and not enough at the very end of the formula.

And yes, Airtable could do a significantly better job of handling stuff like this.