We have a team dashboard that is not showing correct data. It seems that the underlying report is not updating. What is wrong?
Try to change something on the underlying sheet(s) to see if the dashboard is updated and also check the settings in the dashboard and report(s) so that it's set to get the correct data. If you're still having issues, I would recommend to reach out to the Smartsheet Support Team.
I hope this helps you!
Workflow Consultant @ Get Done Consulting
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.
There are multiple source sheets that are feeding the report. The dashboard is populated from this report. There seems to be an issue with the report not updating.
Seems very strange, assuming you have checked your settings and tried some simple updates and making sure that someone hasn't changed the criteria inadvertently?
After some Due Diligence on your part, the suspicion has to be that there is a bug, in which... as Andre suggests ask support@ and give then the ID number so they can check?
Good luck, very frustrating for you.
Is the data not being displayed properly date related?
If i open the report it will temporarily update which will reflect in the dashboard. However, it doesn't save the updates and reverts to the previous incorrect data. It is a nuisance for one, having to log in to the underlying report to make it refresh, but secondly, not save the refresh.
I saw the behavior occasionally in my own testing of the feature back in Q1. At the time, I thought it was resolved.
I haven't seen it recently.
If I find anything in my notes, I'll pass it along.
In the meantime, reach out to [email protected] or https://help.smartsheet.com/contact
I would try the second one first.
No joy from Smartsheet Support
What do you mean? Haven't they got back to you? Are you still having the same issue?
They have got back to me but not resolved the issue. The report that is populating the dashboard is not auto-refreshing even though the source sheets are being saved and refreshed.
From a management perspective, we want to be able to look at the dashboard and know that the information is accurate. Senior Management do not have time to be going into the report/s and refreshing them manually. They expect the dashboard to be correct when they review it.
If you'd like and if it's not any sensitive data you can share it with me and I would be happy to take a look.
Have a fantastic weekend!
Thanks Andrew, how do I share it with you?
You can share it with me thru my email [email protected]
Thanks Andree, I have sent these through by email.
I have a similar problem. The "Current User" sees no rows in Dashboard. However, when he clicks on that report in the Dashboard (the underlying report comes up through the EDIT INTERACTION" feature) the user is able to see all rows there.
Is this a permissions issue?
It's because if you select "Current User" on a report that will be shown on a Dashboard, it will only show it as you are viewing it (or the one that created the report).
Please submit an Enhancement Request when you have a moment.
Is it possible to add a pattern (e.g., diagonal lines) to a dashboard chart?
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
Our builders submit dates at each critical stage. I need to write a formula to show what stage the house is in by the looking at the latest date submitted. Any thoughts to what function i should use. Trying to give the last column "Stage of Job", an answer of Slab, Frame, Cabinets or Final CO, based on the latest date…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.