Sheet has to be open to have dashboard update for metric

Pamela Wagner

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?

Andrée Starå

Hi @Pamela Wagner

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Pamela Wagner

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Pamela Wagner

Yes! This worked. Honestly, not sure how but it works and that is awesome! Thanks much!

--Pam

Andrée Starå

@Pamela Wagner

Excellent!

Happy to help!

Matt Kirby

Has anyone submitted this as a "bug"? It seems odd that the Dashboard is not syncing with the underlying sheets unless there is an external API causing the sync to trigger. We use a formula to count number of days since a specific event and display it on the Dashboard. The sheet this formula is on is for our metrics, no one should need to look at this sheet as part of their daily work, it just collects the information; however, we expect the Dashboard to be accurate and reflect the data as it changes. In this case with the elapsed time formula that is in use, it is not working as expected.