I have a spreadsheet with only about 80 supermetrics function queries. They don't seem to always refresh when I open the spreadsheet. Sometimes they do, sometimes they don't and I'm not sure why.
Why would this happen and is there a way to make sure they run every time?
Supermetrics Functions is not designed for this kind of use. Functions is mean to be ad-hoc way of pulling data that you need quickly. If you wish your queries to refresh automatically, I suggest Supermetrics for Google Sheets or Supermetrics for Data Studio.