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.

Add date/time stamp of when another sheet was updated?


Is there a way to add a date & time stamp to a cell showing the last time the sheet was last updated and saved?



  • MattH

    Look at the Auto-Number System column type. 

  • MetroBOS

    Thank you, MattH.  I tried that, but it seems to add a time stamp for when each row was updated as opposed to the entire sheet.

    Is there a way to get the time the entire sheet was saved?  If not, is there a way to pull in the most recent time from the list of times?

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Using the [Modified] column ...

    If you only want the Date, put this into a Date type column


    If you want both Date/Time, then put this into a Text/Number type column

    =MAX([Modified]:[Modified]) + ""

    I hope that helps.


This discussion has been closed.