Dashboard data updating randomly

FrcoReynoso

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.

Matt Lynn-PCG

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.

FrcoReynoso

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

Andrée Starå

https://community.smartsheet.com/discussion/128687/dashboard-data-updating-randomly

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: 

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 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!

FrcoReynoso

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!