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.
The function TODAY() returns the date but not the time component. I need more granularity, like a timestamp. The autonumber column types "Created" and "Modified" both provide such a timestamp.
You could use a dummy checkbox and either check or uncheck it, followed by a save to get the present timestamp. If you needed to do this for many rows, you could have one checkbox as the "master," say in a column named "Get Time" on Row 1. The rest of the checkboxes could just inherit that change with a formula that looks like =$[Get Time]$1, which would force the modified date to be the current time, once a save has been done.
Using the System Columns to show a timestamp or viewing the history of a cell are the current built in methods for getting a timestamp of a change. You could always manually track time in a Text/Number column.
Travis,
Is there a video that discusses system columns and timestamps in more detail? Thanks,
Hi Tim, we dont have a video but here are Help Center articles which covers System Columns and Viewing Cell History.
