Is there a way to access the current time?

Tom Schlofner

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.  

John Sauber

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.

Travis

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. 

Tim McCarthy

Travis,

Is there a video that discusses system columns and timestamps in more detail? Thanks,

Travis

Hi Tim, we dont have a video but here are Help Center articles which covers System Columns and Viewing Cell History.