Dashboard not updating

Hello Smartsheet Community!

I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students.

=IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today", IF([Deadline Date]@row - TODAY() <= 15, "🟡 Due Soon (" + ([Deadline Date]@row - TODAY()) + " days)", "🟢 On Track (" + ([Deadline Date]@row - TODAY()) + " days away to the deadline!)")))

The formula worksth but what's not working is the Dashboard updating in real-time.

Yesterday, the dashboard had been stuck on 73 days away. I had to refresh the dashboard several times and I mean like 5-6 times before it updated. Here I am today, still an issue. While the sheet is showing 59 days away, the portal is not updating and I'm looking at the published view that my students see.

Can anyone explain this? I have been having a lot of issues with Smartsheet stalling. Do you think it's because of that? I don't want to include this tracker if it is not going to update properly. I was really excited about using this, too. Any advice is greatly appreciated!

Find more posts tagged with

Accepted answers

All comments

Javed Hassan

Hi there!

I have this issue from time to time as well with calculated values - it seems to be an issue with Smartsheet for 'live' updates.
Near-live (within an hour or two) updates shouldn't be an issue. On your dashboard, can you check under View→Auto-Refresh and see if it is set to off? It's a long shot, but worth a check.

Others have had this issue as well, so you're not alone.

https://community.smartsheet.com/discussion/78008/report-not-updating-formula-unless-the-underlying-sheet-is-opened-and-refreshed

jgneely72151

It's set to 10 minutes. I'm having to force it from my end daily to update which is a little annoying. I may just remove it altogether if there is no other fix. 😔

jgneely72151

Thanks for the tip because I never paid attention to that.

jgneely72151

So sorry I did not reply properly.

It's set to 10 minutes. I'm having to force it from my end daily to update which is a little annoying. I may just remove it altogether if there is no other fix. 😔

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.