Compare/Track planned dates vs actual dates

edited 12/09/19 in Smartsheet Basics


I would like to find the best way to track our time slippage in projects. Each project (sheet) in Smartsheet is essentially a big timing plan. However, things don't often go to according to original plans, and the dates have to unfortunately change often. I would like to be able to track how these dates changed, so I can then plot them out in the report (original vs actual dates, but ideally also all the versions in between).

Ideally, I would like to present my project time slippage like in the image below.

One way I was thinking of doing this was to pull up information from the "cell history" log. Can this info be used in Smartsheet reports? Or dashboards?

I would really appreciate any tips on this.

Thank you!