Invalid Reference issue

leah_moore

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?

Kelly P.

@leah_moore

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!

leah_moore

@Kelly P.

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.