Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Unknown Workspace In Report. Not Showing all Data

Shawn R
Shawn R ✭
edited 12/09/19 in Archived 2017 Posts

So we have a manager here who builds reports for his employees and shares those reports. However, we ran into a peculiar issue yesterday. One of the employees reports stopped showing all data. So the manager shared the report with me (I am admin and owner of all sheets on the report) When I click the report, absolutely no data is being reported.

 

When I rebuild the report on my end I can see all the necessary data but the user still has missing data. But what is really curious is that when the manager builds or makes changes to the report all data for me disappears. The only thing I have noticed is that under the Where? section of the report where you specify what sheets you want data from, for me and the user it says "Unknown Workspace" But for the manager it shows all the sheets he added.

 

So....what's the deal here?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    Have you tried having the manager deleting your access to the workspace, then loggin out having the mgr reassign acess and then logging back in?

     

    Just spitballing here because I have never seen that, but that is what I woudl try first.  

    · Share on FacebookShare on Twitter
  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭
    edited 02/14/17

    Was the Workspace name changed since the report was created?

     

    Columns or sheets will do this if their name is changed after being associated with a  report. 

    · Share on FacebookShare on Twitter
  • Shawn R
    Shawn R ✭

    Well, I can't really. Some of the sheets the report is pulling from are created by me and I am the owner. This is what is really strange about this. It doesn't seem to be an issue with the sheets but rather with the report. Just to clarify, the sheets the report it pulling from consists of approximately 15 sheets. At least 4 of those sheets I am the owner of, the rest are split between the two other users we have in our account.

     

    The manger in this case is the one who created the report. The manager is also the only one who sees the report correctly. The user the report is created for only sees some data (missing about half) Me, who the report was shared with today literally sees nothing.

     

    If I edit the report myself and reset the (Where?) column I see everything, but the user the report is created for still only sees half and the manager who created the report sees everything. Once the manager who created the report makes any sort of change to the report, I go back to seeing no data but the user who the report was created for doesn't change. (still missing half the data)

     

    I could ask the manager to delete the report and start over, but after some investigation it seems that multiple reports he created for other users are experiencing the same issue. Which tells me its an error by the report creator or some permissions issue with sheets.

     

    So I am kind of at a standstill until I can figure out what is causing the missing data (which was allegedly there yesterday)

    · Share on FacebookShare on Twitter
  • Shawn R
    Shawn R ✭
    edited 02/14/17

    Tim, no workspace name has been changed to my knowledge, but I will ask the other two users who create sheets and get back to you.

    · Share on FacebookShare on Twitter
  • Shawn R
    Shawn R ✭
    edited 02/15/17

    This is fixed. Wasn't naming but a permissions issue, which I don't fully understand. But thats OK. Just glad its working.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories