#BLOCKED on Dashboards

nerdesigner

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)

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! 🙂