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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…