My spreadsheet is for inventory checking. I use several of arrayformula ,iferror and vlookup. The problem is I just noticed that sometimes the formula does not update. It might because I duplicated the google sheet to a new one to make it work for another month. Here is my formula.
=ARRAYFORMULA(iferror(vlookup(A3:A,'21'!A:B,2,0)))
When it is not updated, it make the entire column blank. And make my inventory count gone wrong. I can make it update by manually goes to the cell and press enter. But that not what I want to do. There are like 100 cells that I have to go through.
And the spreadsheet setting to make it update every minute does not solve this problem.