Access values stored in cell history
Comments
-
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
-
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.
-
I would love this feature as then I could do proper trending analysis without having a separate tracking sheet recording daily values.
-
Has there been any development on adding the request to the enhancement list?
-
I agree this idea would be tremendously valuable.
-
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.Estemum Kamal Lithia
Automation Analyst
-
Need it
-
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.!!!
-
This would be an incredibly useful feature. We need a less manual way of looking into change history for data within a sheet, beyond View Cell History (cell by cell) and viewing the Activity log. Some simple examples of how we would use it:
- Find the rows where our column "Status" changed to a specific value (e.g., "Approved") between 2 dates (e.g., during the fiscal year)
- Find the rows where "Status" changed to one of ("Planning" or "Execution" or "Monitoring") but never changed to "Approved"
- Find out what changes a particular user made to a sheet, including which columns and rows and the value changes (the export from the Activity log is very clunky format)
And, Yes, as someone suggested, we could create columns to capture the information using automation, and we have done that in some cases. But why should we have to make our sheet more complicated just to duplicate data thta already exists?
