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

Brad Jones
Brad Jones โœญโœญโœญโœญโœญโœญ
edited 12/09/19 in Archived 2016 Posts

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

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 10/27/16

    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.

  • gamgc
    gamgc โœญโœญโœญโœญ

    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.

This discussion has been closed.