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.