Last Modify Date based on Comments

rvirkler

I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row. 

Shaine Greenwood

Hello,

There isn't a way to create a system column that will only update when a specific cell or comment is added, but if you're looking for visibility on when comments are added, you might consider enabling highlight changes: https://help.smartsheet.com/articles/521974-highlighting-changes-made-to-a-sheet

You can also use Activity Log (if you're on a Business or Enterprise plan) and filter on just the comments: https://help.smartsheet.com/articles/2476206-track-sheet-changes-with-activity-log

J. Craig Williams

I have used Zapier (www.zapier.com) to populate a checkbox or even copy in the comment into cell -- which would then trigger the Modified Date value.

The Modified By would be whomever set up the Zap.

Craig

gamgc

It’s not a matter of visibility. It’s (obviously) a matter of picking it up programatically after the fact; e.g. in a report. You (may) want an addition or change in the Comments field to trigger an appropriate change in Modified.



This should be a configurable option on a sheet-by-sheet basis as I can see how you mightn’t want it for every sheet.