Displaying actual/planned progress in dashboard
I have a construction gantt programme in Smartsheet with start & end dates and % complete columns for each task plus a 'parent' row for overall progress.
Is it possible for me to take data from this programme to display with a simple bar chart or line graph our actual progress against planned progress ?
Not sure how I can do this has the only % number displayed is the 'actual' one which changes as individual task % are updated. I can't see how we would get the data for planned progress ?
Any help would be greatly appreciated.