My spreadsheet is to verify inventory. I use several of arrayformula, iferror and vlookup.
The problem is that I just noticed that sometimes the formula is not updated. It could be because I duplicated the Google sheet in a new one so that it works for another month.
Here is my formula.
When it is not updated, leave the entire column blank. And make my inventory count badly. I can have it updated by manually going to the cell and pressing enter. But that is not what I want to do. There are about 100 cells that I have to go through.
And setting the spreadsheet to update every minute does not solve this problem.