Welcome!

Formula Permision Error

Yesterday I pulled up a sheet that is pulling information from other sheets owned by someone else with no issues at all. Today I pull up that sheet and all of the cells referencing the other sheets have Permission Errors in them. I still have edit rights to those sheets...

I have edit access to all the sheets.

The only difference is my login password has changed. I have no problems accessing or editing.

Find more posts tagged with

Comments

Willf

Bill,

I am getting the same issue starting this morning. I have Admin access to the sheet I have been referencing successfully with an INDEX formula for the past few weeks. Must have something to do with the new update.

I hope the Smartsheet team can clear this up soon.

Bill Stadler

Have you reported it to them? If not I will.

CieraB

Same thing happened to me. I sent an email to my Smartsheet contacts. Hope they can get it fixed asap that's months of work gone in the blink of an eye.

Willf

Bill,

I reached Tech support on the phone at 8:30 and they are looking into it and possibly escalating the issue.

Some of my co-workers are using cross-sheet formulas on sheets that they are the owner of with no issues today, so this problem might only affect a few of us.

Willf

Just got a call back and they are escalating. Sit tight!

Bill Stadler

Thanks, I reported it as well. Yes it seems to have to do with sheets that I am not the owner off.

Thanks for updating us.

tylermh

This is happening to me as well as of late last night. I'm the owner of all the sheets involved, so that's an added wrinkle to what others are saying on this thread. What's also odd is that I was able to fix the error by re-sharing another sheet this happened to yesterday, but to no avail with the sheet still throwing the error. Please help! Need this fixed for a presentation to executives tomorrow morning!

Kyle Morgan

We began experiencing a similar issue this morning.

Sheet owner reported issues with inbound links from other sheets that he had Admin access to. He rec'd error message stating that the (paraphrase) "link was not valid due to not having valid permissions to referenced sheet".

This morning, the issue was isolated to a handful of random links within the single document. As of 10 minutes ago, all links are effected. - The error message has now changed to "Error: this link is invalid"

Have not contacted Smartsheet yet, as it appears that they are already aware of the situation. Fingers crossed that a fix is on the horizon. The ability for this functionality to function is crucial to our day-to-day.

tylermh

Within the last hour, my formulas with the #PERMISSION ERROR are now back up and running. Hopefully they do a sweeping fix. Good luck!

Bill Stadler

Mine seem to be working as well.

Kyle Morgan

Did a quick spot-check on a few files and it looks like we're good, too.

Willf

Good to go, mine are working this morning!

Sign in to join the conversation!

Quick Links

Trending discussions

Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
how can i overlap 2 tasks.
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Update Automations
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…