Sign in to join the conversation:
I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ?
Hi bzgryzek,
Yes, to a degree. If you have the proper privileges then you can export a Sheet Access Report csv file specific to a particular user via the Account Administration panel.
It will not detail what the user has done within a sheet, however. You would still need to access the Activity log for the accessed sheet and filter by user.
Many thanks, that was I thought. It would be great to have a look on activity log per user for specific period of time requested. I will submit Product Enhancement Request. thanks.
@bzgryzek,
If you want to do a history report by user, the only way to currently do this is with the API. Even still, it may not provide you with all of the changes by user (things like formatting, etc), but I do know from experience that it is possible to do. I find it is better to pull large data out of SS for processing rather than relying on the internal formulas and links.
Czesc
@Brad Jones
I'm trying to figure out a way using the API to collect Dashboard Views / Sheet Views. Do you have an example you can share with me on how to achieve this?
Hi @Jeff Zumaris
There is a premium add-on, Event Reporting that can provide you with much more information.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
@Andrée Starå Unfortunately, no this does not help, I've seen this already. Looking more for the working code behind the example.
@Jeff Zumaris
Ok. I hope that Brad has a method that would work instead.
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
