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.
Hi
Does anyone know if there is a way to time stamp any comments placed into a sheet? I know you can always look at the history of the cell but I was wondering if there was any way that the date would automatically be placed in the cell when someone adds content.
You could add a Modified by date/time system column to the sheet!
Yes that has been one solution. However the team really does not want to add more columns or rows to our sheet. We basically just want to make it look like how it does when you look up cell history.
Hi Jennifer-- Another option would be to use the default Comments (formerly Discussions) column, which automatically attributes and timestamps every Comment!
Unfortunately we already use that as other dialogue for the project.
I will talk with my team and see if that is a viable solution
I use a text replacement utility called Shortkeys for this function everywhere in my work. You can get a free copy that will allow up to 15 shortkeys. Essentially you have a trigger key and code that triggers and inserts a string. Mine for time and date is: "trigger key" + "now" which produces the below.
08/16/16 at 6:25 JM:
That's a brilliant solution, Jeremy! Here's a link to Shortkeys, if anyone is interested. I know a few of my colleagues here at Smartsheet really like TextExpander, which has a similar function as well,
Hi guys. I'm trying to accomplish the same, which is to identify the last date a Comment was added specific to the SmartSheet Comment feature (see screenshot). Creating a Modified Date column via a system column only identifies date for changes made to other columns of data, but not the Comments feature (see screenshot)
Any suggestions?
Hi Catherine-- There's not currently a way to pull data from the Comments column (e.g. time last comment was added) into a column in a sheet, but I've added your vote for this to our enhancement request list!
