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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!