Cell Linking not updating
Hi
We use cell linking to take dates from one sheet to another. This date can change during the lifespan of the job.
Unfortunatly we are having an issue with the cell linking not updating across sheets? I am not talking, instant update, but days later. One cell view says one value and then when you click on the cell and go to the source cell the updated value is correctly in the source cell.
Upsetting our KPI's
Thanks all
Tracey
Answers
-
Hi @Tracey Tume
I hope you're well and safe!
Is it a very busy sheet with a lot of formulas and similar?
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree
Yes you could say that it is but it is DAYS sometimes over a week later - we are trying to access the data for our KPI's so it is very disruptive.
Regards
Tracey
-
I am having the same problem, did you ever find a solution? My linked cells are not updating despite refreshing and saving the pages multiple times.
-
From memory it sorted itself out as we are good now. Seems like a lifetime ago :)
-
We've been noticing a degradation in performance for cell links over the past several months. We do have multiple inbound and outbound links plus cross-sheet formulas in most of these sheets (the whole reason we're using Smartsheet) but we're not hitting up against the limits. We have triggers set up to ensure our sheets recalc each morning but many times the cell links become stale even when the sheet recalcs. We're also seeing a lot of blank values once the cell link is established, even though the source cell has data. Cell linking used to be a really reliable feature and I hope that the backend/platform work Smartsheet has been working on will bring this functionality back up to its prior reliability and that what we're experiencing currently is not the end result of the overhaul.
-
Hi Sarah
Thanks for the heads-up, I have made our team aware of this and they will keep an eye on this.
Good luck!
Tracey
-
Just got my team set up with Smartsheet and the cell linking is definitely an issue. I am seeing blank cells where I have linked data (End Dates from plans), as well as the data not refreshing for some time.
-
@Andrée Starå any update on this issue. Started working with cell links from a sheet that is populating it via a data shuttle. The link just disappears.
-
Also looking for an update on this @Andrée Starå as we are having a similar issue. The sheet is not that large or data heavy but some linked cells are showing up blank despite the source sheet being populated.
-
I also have sheets with live links that connect to cells with data that is not updating. It looks like this issue just died and I cannot find any actual resolutions online. Any updates from technical support at all on this?
-
I am also having this problem. Cell linking is useless if it doesn't update.
-
Having this issue as well, I have about 93,000 cell links on the sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives