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:[email protected] | 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:[email protected] | 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:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.