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?
Best Answer
-
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:Β
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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:Β
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes! This worked. Honestly, not sure how but it works and that is awesome! Thanks much!
--Pam
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
