Invalid Reference issue
I have a sheet where I am pulling data from 3 different sheets into. After a while (eg. if im coming back on to smartsheet) #Invalid ref error appears in all my cells. How do i resolve this without having to edit the formula and relinking the sheets?
Answers
-
As a first step to figure out the issue, I would suggest that the next time you come into the sheet and see the #invalid ref error, right-click in any cell and choose "Manage References." In the pop-up list, you might be able to get some hints about which fields are problematic. Here is more about managing references: https://help.smartsheet.com/articles/2482646-view-modify-delete-cross-sheet-references-formulas#toc-edit-the-formula
Hope this helps your investigation!
-
Thanks for the response!
I think it's something to do with my other sheets and the data shuttle workflow that is ran for each sheet. Any suggestions with regards to this?
Also, nothing appears in the sheet reference manager after this.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!