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.
Reporting When a Sheet was Last Updated

As we struggle with user adoption we are trying to find a way to understand who is and who is not updating their sheets within SmartSheet. I have tried a variety of user reports and system reports, but not seeing a lot that can help with this. At the end of the day we are just trying to see that a sheet had an update done to it within a certain time period. I know I can see a report with all sheet lines and use the highlight changes, but that is way to much information when I need it at the admin level (looking at sheets) and not at the task level.
Comments
-
Yes David you can.
Β
In the sheet linked at the bottom, the green cell in the upper right has the date that the seet was last updated. Β
Β
The row of red cells shows all relevalnt formulas to cut and past into your sheet.
Β
The yellow cells are a mockup of a project sheet. Β The Modified, Last Update, Convert and "Last time Sheet Modified" columns could be hidden on the users sheet. Β Your management report could pull in the green cell from every user sheet and you could see the last time every sheet was updated.
Β
https://app.smartsheet.com/b/publish?EQBCT=8ec0b025b8a843618c78e7f464d1bbc6
Β
Β
-
Thanks for the help - I will work on pulling those in.