Moved Project into another folder and it messed up formulas within project meta sheet
Good Morning,
I created additional folders to organize project folders but it seemed to mess up formulas within my project meta sheet and gave the following two error codes in some sections; #BLOCKED and #INVALID REF. When I clicked into what sheet is being used as a reference it did not show an error within that sheet. I have tried adding formula again but that did not resolve the issue. Has this happened to anyone before? Since those errors are are popping up it has also messed up certain portions of my dashboard. Does anyone have any pointers on how I can fix this?
Answers
-
Moving sheets shouldnt have this affect. Are they large sheets with many references? if so, it could be hitting a limit. Id have to see the sheets in question to diagnose further.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!