Skip to main content

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

  • September 8, 2023
  • 2 replies
  • 57 views

Forum|alt.badge.img

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9768 replies
  • September 8, 2023

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


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9768 replies
  • September 8, 2023

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