Sheet has to be open to have dashboard update for metric
I have a dashboard that has a metric on it similar to what you would see in a warehouse something similar to "# of days since last accident". I have a sheet that has the date of the last accident and then a formula that calculates using a TODAY function. The thing is, unless you open the sheet to refresh it, the data is not going to be correct on the dashboard - it will show the last time the actual sheet was open.
Is there anyway to have my "days since last accident" show up as accurate on my dashboard without having to open the sheet to refresh it?