Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
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
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
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.
