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.
