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.
Feature Request - Comments and Attachments trigger 'modified' column value

I'm trying to create reports that will show my projects the changes to their workspaces over the past day. ย I thought a report would do the trick, and I'd just filter by modified within the last day. ย However, reports don't always catch what you're looking for, like ALL the changes.
ย
Report WARNING, the "modified" system value does not take into account any changes to the comments or attachments. ย So, if you're running a report and looking at changes in the past day, then the report will outright ignore any comment changes unless they were accompanied by cell changes in the target sheet.
ย
If I tell the sheet to highlight changes, it catches all the comment/attachment changes. ย If I get the daily notification for the sheet, then it catches any comment/attachment changes. ย So...
Please fix the reports so that they also catch changes to the comments and attachments. ย (This may necessitate a change to the way 'System Columns' work)
Also, please make it to where my reports can show more than 500lines on one page.ย
ย
It takes way too much time to read through the changes for each sheet every day. ย I need a better solution than going sheet by sheet.
ย
Comments
-
Hello BradโI've made our Product team aware of your feedback. System columns and reports are something of a different beast as they aren't programmed to know what type of cells they're looking at when making the change or pulling in data for the most part.
ย
I've let the team know that you're looking for these features.
-
I was just about to send in a question toย SmartSheets support about why the *heck* my report wasnโt picking up a modified row in a sheet when I realised that the problem was thatย SmartSheets didnโt think that changing a comment constituted a modification to the row. Wow - how out of step with applications like IT Help Tickets where you would record developments in the Comments field.
And itโs not (just) a question of Reports. This is about a change to Comments triggering a change to the Modified column. The report would then pick it up by virtue of *that* change.
This should be a configurable option on a sheet by sheet basis; i.e. whether changes to Comments or Attachments trigger a change to Modified.