Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there a way to access the current time?
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.
Comments
-
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.
