Tracking user activity across sheets

Katie S.
Katie S. ✭✭
edited 02/21/25 in Smartsheet Basics

I am trying to understand all sheets a specific user viewed in a given period of time. I can go sheet by sheet to pull this info (we have over 2K sheets). Does anyone know of a more efficient way to get this info. I have the user type report, and see the quantity of views the user did, but not the assets they viewed.  Anyone have guidance?

· Share on FacebookShare on Twitter

Answers

  • kowal
    kowal Overachievers Alumni

    hi @Katie S.,

    If you have SysAdmin permission on your organisation you can download the Sheet Access Report - It shows with which sheets the user is shared etc.

    What you can do but it's also bit manual but faster. If you go to each sheet. Download The activity log as CSV you can merge those CSV and read from all at once. But if it's like 100 sheets then you will need to download and merge those 100 times :(

    Tomasz Kowalski

    Experienced IT PM and the Real Smartsheet Enthusiast.

    Is there anything else we can help you with? - book your time.

    MASA Consult - Your Aligned Smartsheet Gold Partner

    Find us on LinkedIn & Check our Smartsheet Solutions!

    Tag my name: @kowal if you want me to respond :)

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video