Resource view - Other Sheets

Shaikk
Shaikk ✭✭
edited 01/31/22 in Smartsheet Basics

I have admin access, and I have access to all the sheets.how to identify the source sheet of 'Other Sheet' in resource view. I have downloaded 'Sheet access report but can't find the NOT shared sheets. A small suggetion would help me a lot.

Thanks

Best Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Shaikk

    Downloading the Sheet Access Report is exactly what I would suggest doing. "Other Sheet" will appear if you're not shared to this sheet, and the Sheet Access Report should show you all the sheets in your company's account. (See: View Resources across multiple sheets)

    From here you should be able to find a list of all the sheets that you are not shared to. Once you have this list, you can ask the owners of these sheets to check if they have turned on Legacy Resource Management in Project Settings.

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • kwallace
    kwallace ✭✭
    Answer ✓

    Question - Have you noticed that when you run the user sheet access report, it's excluding sheets and reports owned by user. I've noticed this recently and I did open a ticket with Smartsheet support. For example, when I ran report for myself and filtered on everything that I own, it only reflected my dashboard's.

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Shaikk

    Downloading the Sheet Access Report is exactly what I would suggest doing. "Other Sheet" will appear if you're not shared to this sheet, and the Sheet Access Report should show you all the sheets in your company's account. (See: View Resources across multiple sheets)

    From here you should be able to find a list of all the sheets that you are not shared to. Once you have this list, you can ask the owners of these sheets to check if they have turned on Legacy Resource Management in Project Settings.

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Shaikk
    Shaikk ✭✭

    Thanks @Genevieve P. for your response.This would help me a lot. Thanks again!!

  • kwallace
    kwallace ✭✭
    Answer ✓

    Question - Have you noticed that when you run the user sheet access report, it's excluding sheets and reports owned by user. I've noticed this recently and I did open a ticket with Smartsheet support. For example, when I ran report for myself and filtered on everything that I own, it only reflected my dashboard's.