Sheet Access List

Options

Is there a way to export a list of all users that have access to a sheet. It doesn't appear so to me but I thought I would ask just in case I am missing something.

Best Answer

Answers

  • Guy Behanna
    Guy Behanna ✭✭✭✭
    Options

    JP,

    Request a sheet access report in the "More Actions" menu within the User Management section of the Smartsheet Admin Center. A .csv file will be emailed to you that includes all sheets in your account and all users shared to each sheet, among other data. Once opened in Excel, you can then either filter the list or create a pivot table to easily see the users assigned to any sheet in your account.

    Hope this helps.

    Guy



  • JP Pedicino
    JP Pedicino ✭✭✭
    Answer ✓
    Options

    Excellent, thank you!

  • gerald.leddy
    edited 09/19/22
    Options

    Is there a way to download the list of people that have access to a single Sheet?


    One of our frequent use cases involves sharing a sheet globally with a large number of people. It is very difficult to scroll through the small pop-up window to confirm/audit access. There has to be a better way to check sheet access than pulling an 'Account' level report in User Management!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!