There are issues with both the sheet formulas and the reports. Could you please check this?

Question

I am posting here because our team is facing a critical issue and we've been unable to use our sheets for several days now. We are currently on a Business Plan and have already submitted three official support tickets

through the AI assistant

, but unfortunately, we haven't been able to reach a Smartsheet engineer or support agent yet.

Here is what is happening:

First, all the content and data inside our report have completely disappeared.

Second, whenever we try to modify or edit any column within the main sheet, we get a "Sheet not found" error and cannot proceed.

This issue is causing a major blocker for our daily business operations. Has anyone experienced a similar glitch where a sheet suddenly can't be found upon column modification?

Any insights, workarounds, or advice on how to get an urgent response from the support team would be greatly appreciated.

Thank you in advance for your help.

zeep · Answer

ㄴ Same user - note the identical avatar - appears as "Editor - can share" in the header and as "Owner" in the share list below. The workspace is also shared to a group (Group - 9 members) with Admin. Names and emails are masked.

ㄴ Clicking "Request admin access" confirms it: "You currently have Editor - can share permissions." The sheet's owner is being asked to request admin rights on his own sheet. Note it also states that Admin is required to edit locked columnswhich is exactly what we cannot do.

ㄴ From a working copy in a personal Sheets folder, creating a cross-sheet reference to an ORIGINAL sheet in the group-shared workspace fails: "Unable to create the requested cell link(s). The source data is no longer accessible."

ㄴ Same sheet, same dialog, different target. The four columns re-pointed at copies in the personal folder return real values (current stock 20 / 51 / 133, last-30-day 4 / 2 / 48), while the columns still pointing at originals - author

name, import schedule, trimmed mean - remain #REF. One sheet, one screen, same kind of formula. Only the target differs.

Andrée - thank you, we tested it. Here is what we found.

Copying the sheet does not fix the original, but it isolated the problem.

* A copy saved into the ORIGINAL workspace fails: "You do not have sufficient

permissions in this workspace to make this change" - for a System Admin.
* A copy saved into a personal Sheets folder works, fully editable.
* From that copy, referencing an ORIGINAL sheet - one that lives in the

group-shared workspace - fails: "Unable to create the requested cell

link(s). The source data is no longer accessible."
* From the SAME copy, referencing another COPY in the personal Sheets folder

resolves correctly with real values.

Same sheet, same dialog, same method - only the target differs.

So cross-sheet referencing itself works. Access to the original objects does not.

The clearest single symptom: on the affected sheet, Share > Manage access

lists our user as "Owner" while the header for that same logged-in user reads

"Editor - can share", and Smartsheet offers a "Request admin access" button.

The permission record and the runtime check disagree.

Our workspace is shared to a group ("KBG ALL MEMBERS", ADMIN). The affected

user is in that group but gets "insufficient permissions". The broken

dashboard widgets say he is "no longer an Admin on the source report" - his

Admin came through that group, and nobody removed him. Activity Log shows

zero permission-change events.

Scope: 94 of 1,315 sheets, 11 of 29 dashboards. No sheet fails to open and

282 of 283 reports open fine over the API, so nothing was deleted. Only

specific sheets are affected; the rest edit normally.

Our case 09786267 is In Progress but we have had no contact. As a Smartsheet

Partner, would you know how to get an escalation engineer assigned to check

group permission inheritance on this account?

Andrée Starå · Answer

https://community.smartsheet.com/discussion/147877/there-are-issues-with-both-the-sheet-formulas-and-the-reports-could-you-please-check-this

Hi,

I hope you're well and safe!

Strange! Have you tried making a copy of the sheet?

Did that work/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! 🙏

Andrée Starå · Answer

Hi,