Google Table CTRL + Shift + E

Question

I have a table with two sheets: current_sheet and archive_sheet .

I also have a script (which I created) that removes data from current_sheet and adds it to archive_sheet once a month.

The sheets have an arrayFormula , and after each monthly operation, moving the cells with this arrayFormula ends without any results - and I get a warning message indicating that I must press Ctrl + Shift + E to solve the problem.

Once I have done this, the formulas work again. I am wondering how I can change my script so that I do not need to provide this fix every month?

Answer 1

use a timed trigger every month script

Answer 2

Instead of using a script to move your data every month, try copying the values, then clear the original data and reinitialize the formula. Without seeing my formula and not understanding what you are doing, I am curiously punching in the dark.