#BLOCKED on Dashboards

Hi Community!

I have built a data visualization dashboard that runs off a "summary" sheet. The summary sheet is all formulas that average data from a master sheet.

My problem is, instead of the Dashboard updating live based on the data in the summary sheet, it breaks and shows #BLOCKED every time the master sheet updates. The summary sheet formulas do NOT run until I, the admin, open the sheet--then suddenly everything looks fine.

What can be done? My clients can't see the data in the dashboard. It's attached to a Smartsheet form, so in theory it should be completely live each time a new response comes in and just alter the charts--but instead the whole dashboard becomes error messages.

Any help appreciated! Thank you!

(Added a photo)

Screen Shot 2020-06-03 at 5.03.46 PM.png

Find more posts tagged with

Formulas

Dashboards

Accepted answers

All comments

nerdesigner

Well, user error. This was due to copy & pasting formulas including sheet references! Once I recreated the sheet references everything updated nicely 👍️

Genevieve P.

Glad to hear you figured it out! 🙂

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