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

MetroBOS

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

Using the [Modified] column ...

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

=MAX([Modified]:[Modified])

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

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

I hope that helps.

Craig