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!