Exporting History Data

Trenton Carpenter

I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or an entire sheet's) history? 

 

Currently the only two options I can see are either right clicking on each cell individually, select "view history", then manually record this history data by hand. This would be extremely prohibitive as the pop-up window can't even be highlighted and copied to the clipboard. The other option is to intermittently save a copy of a schedule as the project progresses, then infer differences. Neither of these options will work for my purposes as I would like information for hundreds of cells, and the projects I'm interested in investigating have already completed.

Any help or ideas would be greatly appreciated.

 

Trenton

dAVE Inden

You can get cell history via the Smartsheet API. You can target specific cells on a sheet to see all of its history. More info is in the docs here:

http://smartsheet-platform.github.io/api-docs/#get-cell-history

Brad Jones

+1 to this, but in a way that does not require I learn how to write code.

Maxime Vanwynsberghe

yes, i'm no coding guru either, I need to be able to pull the history from a sheet in an easy manner