Moved Project into another folder and it messed up formulas within project meta sheet

Options

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?

Tags:

Answers

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!