Formula does not run itself

Support
1

When I overwrote the ’ exchange rate ’ in the sheet, I found that the related formula did not run itself and it remained the same order data unless I forced a recalculation. Is there any way to set it up so that it can run automatically when the number has been overwritten or what is the solution?

1 Like
2

Hi there - how did you overwrite the “exchange rate”? For example, was it through an action button, link & load, or something else?

1 Like
3

I did it with the |Tools- Mass Update|

1 Like
4

Thanks for confirming. After you perform a Mass Update, the formulas don’t automatically recalculate. This is due to a key rule in Ragic: formulas only trigger when data is entered or edited directly on the sheet where the formula is defined. (More details here: Why didn’t the formula trigger?)

If you’d like formulas to recalculate after a mass update, you can use one of the following methods:

  1. Go to Design Mode and run a Formula Recalculation on the sheet.
  2. Add an Apply All Formulas to This Record Action Button to trigger recalculation manually when needed.
  3. Set up a Daily Formula Recalculation workflow if you want formulas refreshed automatically on a daily basis.
2 Likes