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.

Smartsheet Directory

Stephanie TaylorStephanie Taylor ✭✭✭✭✭
edited 12/09/19 in Archived 2015 Posts
06/03/15 Edited 12/09/19

I made a directory listing all of our smartsheets with a brief discription of the sheet.  I made the name of the SS a hyperlink that takes you to that SS.  I then shared the directory with my office.  My problem is if there is a sheet someone in my office wants to access but the sheet has not been shared with them then I want them to be able to click on the hyperlink and have a request sent to me so I can share the sheet with them. 


Can this be done? 


  • If someone clicks a hyperlink for a sheet where they don't have access, then they will get a message and a button to allow them to request access.  The owner of the sheet will then get a message and can grant access.

  • Stephanie TaylorStephanie Taylor ✭✭✭✭✭

    I thought so too but they are getting a message that says: "The item is not currently available - it may have been deleted or your permission may have been removed from it."


  • edited 06/03/15

    I think when they get the message you noted they are also provided an option to request permission which sends the request to you.


    I would LOVE for SmartSheet to come up with an option for users to print out a "Map" to all the Workspaces / Sheets they are shared and that does NOT show them items they are not shared too.


    That would cut down the requests (for example) from non-management employees to see the Management Only Workspace because they wouldn't know it exists to request. I've had to create my own Map and then go in and take out the items that people shouldn't see are available to send them their own special Map of what they have access to so they know where to go for stuff. 


    That was probably really long winded but I don't know how else to explain it. Wink


  • Stephanie TaylorStephanie Taylor ✭✭✭✭✭

    Thank you for your responses.  But please note that the employees are not getting the option to request permission.  If they were I would not be asking this question.

  • TravisTravis Employee
    edited 06/03/15

    Stephanie is correct, the user will not have the option to request access, although it seems like think they should. I will bring this up to our product team the next time I meet with them. In the meantime, you can hyperlink to the sheet URL, rather than linking “to other Smartsheet”. To get the URL for a sheet, click the Sharing tab at the bottom of the sheet. If they are not shared to the sheet when clicking the sheet URL, they will have the option to request access from the owner. 

  • TravisTravis Employee
    edited 06/03/15

    Bobko - SysAdmins on team or enterprise plans can download sheet access reports which shows all the sheets a user is shared to. To produce this report, right click on the user under User Management and select Download User Sheet Access Report. 

This discussion has been closed.