#BLOCKED on Dashboards

nerdesigner ✭✭✭
edited 06/04/20 in Formulas and Functions

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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!