View original (French)

[Google Sheets] Show cell modification date

Solved
Cmoi2025 -  
I am transferring my question to the right section

Hello

I need to display the modification date of hundreds of cells in a column in the right column next to each relevant cell.
Is there a function that displays the modification date (and time if possible) of the cell on the left?

Thank you in advance

3 answers

  • Votes
  • Date
  • Descending date
  1. PapyLuc51
    Hello Cmoi2025

    After some research on the subject, I found an Excel file and reproduced the settings on a Google Sheets spreadsheet, and it seems to be working; see the image below.



    However, there is no automatic change when modifying cell A; you have to delete it before entering a new value.

    Best regards
    1. Cmoi2025
      It works well, thank you.

      I thought that with the latest cell history feature we could retrieve the information to display it in another cell.
    2. PapyLuc51
      Hello Cmoi2025

      I don't know how to do it either from the cell history.

      However, by clicking on the underlined mention "last modified ....", it opens the version history, and by clicking on each created date, it highlights the corresponding cell. You have the option, by clicking on the three dots on the right, to name each version as you wish or to create a copy of the version in your drive.

      I haven't found anything else.

      Best regards.
  2. Raymond PENTIER Contributor
    No : The system logs the creation, last print, and last modification times of the entire file !
    Not of a sheet, a line, or even less a cell ...

    --
    Retirement is good! Especially in the Caribbean ...
    Raymond (INSA, AFPA)