1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.