Cell links and cross sheet references breaking
Recently we've had more and more issues with cell links and cross sheet references not updating correctly.
For cell links we're finding that the link breaks, unlinking and re-linking doesn't solve the issue as it just reverts to the incorrect value. A workaround is to un-link the cells, link to a different cell than the desired, save, un-link again, then link to the desired cells.
For cross sheet references we're finding that rather than breaking the values in the cell are alternating between the 'correct' value and a mysterious past value:
We're using data shuttle to pull this data through, the correct data is there but Smartsheet seems to be seeing some other value as well.
This issue has been seen in the past very rarely but over the past few weeks we've seen this issue increasingly and it's affecting the usability of our sheets (the business is very reliant on these).
Has anyone else had the same issue and if so, any potential fixes?
Answers
-
I'm having the same issue. I just submitted my large monthly dashboard to our CFO only for him to find significant errors. My base sheet pulls correctly in one grid but pulls in a completely different number to another. I've removed the link, cleared the cell, and relinked. Same error. This is not good as this has happened through the 6-page report.
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
I would suggest reaching out to Support on this one. It sounds like there may be a bit of a bug on the back-end.
-
Same issue here- I hope this gets corrected soon- and for good.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 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!