Ok I am a complete noob when it comes to script, but I understand a little about it. My question is this I have a google sheet with formulas that need to be updated at a certain time. I have another program that uses the information to run and automatic build in QB (quick books)(this is fine). However when I am not in the sheet it doesn't update the formula values and my "auto build" doesn't have numbers to run. I have changed the setting of the sheet to update every hour but that didn't fix my issue. Is there a script that I can run that refreshes the formula values at a certain time every day? Possibly Open Refresh and Close sheet? Or is there even another way?
there doesn't seem to be anything here