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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!