Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Since yesterday, we are experiencing the data value errored out and a couple of minutes later, it fixed itself. Does anyone have the same issue?
Hi,
I hope you're well and safe!
Strange! Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Have a fantastic day!
Andrée Starå | Smartsheet Expert Consultant and Partner / CEO @ WORK BOLD
✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏
Since it fixed itself, it is hard to troubleshoot.
This may be related, yesterday I noticed the title rows on our schedules shifted to yellow instead of the navy blue. I checked conditional formatting and found no issues there so I went to the Metadata sheet and for a brief second or two it was blank. The data came back and I saved the sheet. When I went back to a related schedule, the yellow title row then updated back to the navy blue. It's back again this AM so I'm keeping an eye on it. No data is lost but it's like a connection is briefly dropped or something.
@melissalk , I think we are having the same issue and glad you posted it. We contacted the help desk but did not get the answer yet. We were wondering if that is happening just us or everyone. I checked the Smartsheet Status but there was no report yet. One of the sheet we had the issue with related to the metadata sheet, and our metadasheet have the formula with the references. I assume you have used the reference in somewhere in your formula as well. When you open the source data, i.e. metadata sheet, the sheet itself fix itself.
We started experiencing cell link issues at exactly 11:00 am PST yesterday (Aug 24) across 160+ sheets.
Dates linked in from Metadata sheets were erroring out. We went in and manually refreshed all of the sheets and thought it fixed the issue - however, minutes later everything errored out again. I came in this morning to find the same errors across all sheets.
The Project Date column is linked in from a Metadata sheet (yes, both column types are set as "Date"). When physically opening the Metadata sheet, you can briefly see "#DATE EXPECTED" flash in the cell before it resets to show an actual date. Saving the sheet again temporarily fixes the issue. This is what we did yesterday. We opened the Metadata sheet. Waited for it to refresh with a date. Saved, open the destination sheet and the issue seemed to fix itself. However, after some time, the issue reappeared again.
I am stumped.
I will be submitting a ticket if the issue does not resolve itself shorty. I will not open, refresh and save all of these sheets again only to have them reglitch.
@Kyle Morgan , exact the same thing. I think your reference is shifted the next column of your source "date" field. We had the exact same issue from yesterday, 1:30 pm in Eastern Time in US. My colleague just finishing the call with Support team and they said they will escalate the issue. We'll see. I have many users using the Smartsheet and the issue have been reported more this morning.
@Makiko Joans we are having the same issue… started happening yesterday with 350 sheets and 100 dashboards affected. The Activity Log shows a Cell Link event changing a formula result from the correct value to blank without a formula edit or change in the cross-referenced source sheet.
Check your activity log and cell history and you'll see the pattern of the issue. My theory is that the cross-references are failing due to changes in table view.
Example from this morning:
I also went in and ran an API script to try and force a save/update by recording today's date in every row so that I wouldn't have to fix the issue by going into each sheet and saving it (potentially multiple times if it kept getting overwritten) and it didn't work. So the fixed that worked for me was to go into every sheet, wait for it to load, click save. Ours also started yesterday around 11a PST
@everyone, I think we are having the same issues. Not good..
Reached out to support. They were able to replicate the issue. Issue has been passed along to the team. Fingers crossed that a solution can be found. This error has basically cost me months of work. :(
Great! Thank you! I am glad that they were able to identify the issue. We have 1000s of sheet and hundreds of users. It is creating the confusion around the users and I am working with my colleague all day about this to identify if the issue is caused by this or something else… Thank you sharing the update!
Well… I hope that they can identify the cause (and fix it). The support rep was only able to replicate the issue on my end, thereby confirming I have a problem. Unfortunately, they were unable to offer any possible cause or solution.
I agree. This is causing a LOT of confusion on my our end and I have been wracking my brain trying to come up with a fix. But, every time I think I have it fixed, the issue reverts everything back and the error messages appear again.
@Kyle Morgan what did you already try to fix it?
I was thinking about deleting and recreating the cross-sheet references to see if it resolves the issue.
I've already tried recording today's date in every row using the API, didn't work.
Ok, so the incident has been now added to the Smartsheet status website, but Smartsheet team responded to my colleague that there is no ETA on the permanent fix. So, is there temporary fix?
Smartsheet Support marked the issue as resolved last night but the issue persists today. I manually updated one project as a test and it reverted back to the same issue within ten minutes. It's now been a day and a half with huge negative impact and no real progress made towards resolution.
I'm getting the error "unable to sync cell link details." Is anyone else getting that error? Not sure if it's related or not. Currently on hold with support and the AI bot couldn't help
Good morning, I think we are having the same issue from yesterday… there are other issue popping up in the Smartsheet status; https://status.smartsheet.com/. Not sure what's going on, we will keep eyes on it. Hopefully it get fixed soon.
Not sure if the issue is resolved or not. All of the error messages (i.e. "#DATE EXPECTED") are still present. So, if the issue was resolved, it did not refresh the data as I had hoped.
I did go in and manually refresh 1 project, manually saved and it appears as though the data is holding. It has been approx 45 minutes and it has not thrown an error. I hate the fact that I may now need to go in and manually refresh 150+ projects but, it is what it is I guess. Just another normal day as a Smartsheet Admin 🙄
But, for the record, I already manually refreshed all of the projects once before (yesterday) only to have them throw errors - so, I will be a little more deliberate this time around (a few at a time, wait and watch).
I'll report back later if anything pops up.
I've also started a support case on this yesterday, and just saw this message this morning. I'm glad to hear several members have reported the issue to Smartsheet, so hopefully Smartsheet resolves the issue soon.
Cell Links across multiple sheets have been changing on me constantly through the day, since approximately August 24 11:30 AM PDT. I too am manually refreshing as many of my important sheets to force the cells back to the correct values. It's not a sustainable solution, so looking forward to the fix.
Hello, hello Community, I hope you’ve had a chance to dive into the responses from October’s question, they are packed with incredible recommendations. If you’re on the hunt for your next great read or watch, the Community definitely delivered! A new month means another chance to connect with your peers, and earn a…
I currently have 18 seats of the smartsheets business plan. I would like to modify my payment structure from annual to quarterly. How do I accomplish that?
Why am I getting this error. The source report has data but its not shown in dashboard
