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.

Sheet summary values not updating on dashboard

L_123

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.

Find more posts tagged with

Accepted answers

All comments

Heather Duff

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

Julie Taubman

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.

Marcela

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,

Patrick Yaeger

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?

Laurie Mason

@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.

James Emge

Same issue, have to go into the source sheet and get the symbol value column to update then link out to the reporting dashboard.

Marcela

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.