Access values stored in cell history

KCam

We are desperate for this functionality for project management analysis. We are date stamping when a project changes Development Status, but I need a full history that can show specifics (status, entered by who, date, etc). Please!

Karla

mdemul

I agree with previous posts. I'm tracking changes to sheets including archiving of rows and moving rows to another sheet (with archived data). I was asked to create a historical report on what rows were created and archived when, and this is near impossible. I'm manually copying data from the cell history.

If there was a formula to access cell history, this would save a ton of time.

Clarkathon

I would love this feature as then I could do proper trending analysis without having a separate tracking sheet recording daily values.

Gabela

Has there been any development on adding the request to the enhancement list?

LC184844

I agree this idea would be tremendously valuable.

Estemum Kamal Lithia

Sometimes, to reward someone who has updated sheets properly on time, we need to check the history of each cell. Similarly, if incorrect data is entered, we need to identify the user responsible by reviewing cell history. It would be beneficial to have a formula or feature, such as HISTORY(), "Get Column History," "Cell Changed By Whom," or "Cell Change Date/Time," that provides this information directly. This would simplify the process of tracking changes, saving time, and reducing manual effort for users.

Charles_M

Need it

rishabh.sharma25

Create a column with a date format "Last Modified Date".

Now, create an automation record a date to the column when the status was changed.

It will work.!!!