Welcome!

Baseline Programme in Gantt View

Morning All,

I reviewed the following resource to setup a Variance column to calculate the variance between a Baseline Programme and actual performance. (Gantt View)

https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance

I can get the raw Variance to display, but it fails to account for Working Days.

ie, a one week delay is showing as 7 days,...when it should only show as 5.

The help article says"

In the top row of the Start Variance column, create a NETWORKDAYS formula that counts the number of working days between the Planned Start and the Actual Start. For this example, the formula is: =DATEONLY(Start2) - [Planned Start]2

Any ideas?

Chris

Find more posts tagged with

Comments

Alejandra

Hi Chris,

Using the NETWORKDAYS function instead of the DATEONLY would get you the results you're looking for, but I do see how the wording can cause confusion.

Please know I've submitted a request to get the article changed.

More information on NETWORKDAYS can be found here: https://help.smartsheet.com/function/networkdays

Chris_Bick

Excellent, Thanks Alejandra,

This solved my issue and it works well

Chris

Steve Mager

Does anyone know where the instructions from this link can be found now? https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance

Thanks,

Steve

Andrée Starå

Hi @steve mager

Not sure I follow!

Which instructions do you mean?

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Trending discussions

Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?