Baseline Programme in Gantt View

Chris_Bick ✭✭
edited 12/09/19 in Smartsheet Basics

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)

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?