Dashboard data updating randomly
Hello,
I have this Dashboard that pulls data from a sheet, I'm having this issue with the chart widget specifically, somedays the Dashboard would be showing updated and correct data, some other days the Dashboard would show random data, what really troubles me is why somedays this is up to date and working fine and some other days it would take the whole day to update and show the correct data. Has anybody deal with this?
Snapshot is how it looks when is working properly, and somedays this pie charts are all showing Status red, even though the source data hasn't change.
Answers
-
Does this underlying data source: A.) Get opened every day by someone or is it a calculation sheet only? B.) Does it include the today() formula in it's calculations?
Sometimes calculations are slower to update if they're never being nudged along and or if they have the today() function. That function only knows what the date is IF that sheet has been opened/touched on each new calendar day. The easy work around on this is to add an automation that occurs every day. I usually add a hidden helper date column and just have it log/record a date each day at 5am or something. This will force the date to update but also sometimes help nudge calculations to update even if they're not the today() function. Just an idea.
-
Hello Matt, I appreciate your input,
A) Data source does get opened every day
B) Today() function is used but the sheet is open on a daily basis. I should check on that automation work around -
Hi,
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 day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
Hi @Andrée Starå,
I did implement that automation to my sheet 2 but I did not see any changes. Thank you for your input!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives