Sheet summary values not updating on dashboard
I'm having issues with fairly basic date based formulas not updating in a dashboard.
A sheet I have that has
7 Columns
23 Rows
0 Calculations on the sheet itself
and 3 basic formulas in sheet summary columns
- =IF(COUNTIFS(Date:Date, TODAY(), Shift:Shift, "1st") > 0, "Green", "Red")
- =IF(COUNTIFS(Date:Date, TODAY(), Shift:Shift, "2nd") > 0, "Green", "Red")
- =IF(MAX(COLLECT(Created:Created, Shift:Shift, "3rd")) > MAX(COLLECT(Created:Created, Shift:Shift, OR(@cell = "1st", @cell = "2nd"))), "Green", "Red")
The sheet summary values will not update in the dashboard when users submit form entries without me manually going into the sheet and saving it, and even then it is still taking a while.
I'm starting to have quite a few speed issues with several of my smartsheets, but this one in particular is perplexing as I don't see any reason why this would ever have a problem updating. Is anyone else seeing these issues coming up?
I've submitted a ticket to the support center as well.
Answers
-
Hi @L@123 ,
I have not experienced that problem, but I'm sure it's frustrating! One workaround would be able to create a separate roll-up sheet with cross-sheet references to compile that summary data. Then you can have your widgets pull the data from the separate sheet. I have (so far) had no trouble with my roll-up sheets updating almost instantaneously, and updating on the dashboards just as quickly.
Hope this helps!
Best,
Heather
-
I'm have a similar issue - Metric widget was reporting sheet summary data then started showing an error. The underlying data is still there. Now, I select the Sheet sheet summary data, hit OK, but can't proceed with setting up the widget. Perplexed.
-
Hello everyone,
Appreciate your reports on the observed behavior. We've applied a solution for Dashboards and are keeping a close eye on the outcomes. For additional details or to stay informed, visit our Status page at https://status.smartsheet.com/.
Cheers,
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I am also seeing Summary values NOT updating on a dashboard. I must go into the sheet and save for the values to update on the dashboard.
How can I get what are supposed to be LIVE! metrics updating in real time as expected?
-
@Marcela I am still experiencing this issue intermittently. Can you provide an update on the sheet summary data not updating on a dashboard? Looks like @Patrick Yaeger was still experiencing this last week also. Thanks.
-
Same issue, have to go into the source sheet and get the symbol value column to update then link out to the reporting dashboard.
-
Hello all!
Thank you for reaching out. The previous incident has been resolved. If you're encountering a new issue with Reports not updating on your Dashboard, please don't hesitate to contact Smartsheet Support. To expedite assistance, kindly provide your Report URL, a screen recording demonstrating the behavior, and the URLs of the source sheets involved. Our team will be ready to assist you promptly.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives