Google spreadsheet formula not updating
My suggestion is based on the fact that your script has not advanced work such as URL fetch, just data work, as without actual data read, I cannot give a precise solution with QUERY.Regarding the cache feature mentioned by Henrique Abreu (I don't have enough reputation to comment directly under his answer), I did testing and found that: applying that custom function adder() in sheet by calling a cell, and then changed that cell value forth and back, each time I see the loading message and total time more than 5 seconds.) cell depend upon it and include a formula that is dependent upon the time.=if(now() = D3,”x”,”y”) where D3 is the cell that doesn't appear to update regularly.I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client.
usp=sharing Page two: https://docs.google.com/spreadsheets/d/1R86_0Sr Aty IJPAh MW0Ura-3gw OLn5l9u7Seuj2V0YCA/edit?
If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I am not sure but you might try making another (hidden?
Unfortunately, you can't have custom functions without this amazing feature.
So you'll have to either change it to receive the values directly, instead of the sheet name, or do not use a custom function.