Gantt - Progress Ahead or Behind Schedule?

Hi All

I'm keen to look into options to report on project progress against schedule.

Generally we set a project programme, then progressively update %Complete against lines and the project progresses.

The progress bar works well as visually indicating if each activity is ahead or behind the current date.

I'm looking to try to measure this progress. (ie, 10 days ahead......or 6 Days behind)

In the attached programme, the project is indicating its approx 6 to 7 mths ahead of programmme. How can i get a column to automatically tell me how many working days ahead?

Thanks!

Annotation 2019-04-11 114244.png

Find more posts tagged with

Construction

Formulas

Gantt View

Project Management

Comments

IanN

Hi Chris,

What you're describing sounds like Baseline functionality and while Smartsheet doesn't currently have this built-in, you can mimic the functionality with a few additional columns. I recommend checking out our Blog post here: https://www.smartsheet.com/blog/quick-guide-mimicking-baseline-functionality-smartsheet.

There are also a number of Posts here on the Community that go over Baseline, so you might look for those too.

Hope that helps!

Ian

Paul Newcome

I use a similar idea to the one in Ian's link. I don't often use dependency settings because of various restrictions, but I do use Projected vs. Actual for date columns.

I then build out a chart with dates going down two columns (usually the Monday and Friday of each week). I'll use a COUNTIFS to find out how many tasks' projected dates fall within each week and another for the actuals.

I can then use a Chart Widget on a dashboard to map out our projected vs actual percentages as the project moves along.

Having the table built also allows me to determine how many tasks are ahead of schedule, on track, or behind for each of the "owners".

Renaldo Vilonel

@IanN - I'm looking for some baseline functionality and noticed your link but it doesn't take me to a blog. Can you perhaps confirm where I can have a look at this.

Peter Graham

@Paul Newcome - Can you please share info on your Baseline method and chart above? The first link doesn't work and I'm keen to start tracking project against a baseline.

Thanks

Paul Newcome

@Peter Graham I have 4 columns in my Project Plan. Baseline Start and Finish and Actual Start and Finish.

I then add in 4 more helper columns. Two date type and two text/number type.

In the date type I have the Monday and Friday dates.

In the first text/number I use a COUNTIFS that counts how many tasks have PROJECTED dates for each week.

In the second text/number I use a COUNTIFS to count how many tasks have an ACTUAL finish date for each week.

I then use a Chart Widget on a dashboard to graph the two.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.