Schedule Variance

How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.

Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to add the columns themselves, but then you can copy/paste the data.

  • How do I add the capability to add schedule variance? That is what I am trying to add.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

  • maybe you can also help me...I have done what is described above...

    Actual Start, Actual End, Actual Duration and Task Schedule Variance. (I even have the Actual Duration skipping weekends.)

    Problem now is getting the PROJECT level Schedule Variance for right now.

    So that would be the sum of the Task Schedule Variance...but (and here is the trick) NOT including any Parent Rows where this is calculated. I'm creating a template for my organization and don't want to have to worry about making sure people don't copy a particular formula into Parent rows.

    I'm attempting to use the "Sheet Summary" function. When I try to use "SumIF" as follows:

    =SUMIF([Task Schedule Variance]:[Task Schedule Variance], COUNT(CHILDREN()) = 0)

    It parses but just gives me zero. If I change it to <> 0 it also gives me zero.

    When I try putting @Cell or @Row in CHILDREN() it becomes unparseable.

    Thanks for any help...


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 02/05/20

    @Robert Gibbs Try adding in a helper column of the text/number type. In that column you would use a formula along the lines of

    =IF(COUNT(CHILDREN([Task Name]@row)) = 0, [Task Schedule Variance]@row)

    Then you can use a basic SUM function in your Sheet Summary and add up this helper column.

  • So the @row reference doesn't work in a Sheet Summary Field? Doing it this way creates issues with making sure formulas are copied down correctly...

    But I suppose I already have that problem with the Task Schedule Variance Column...


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @row does not work in Sheet Summary fields.

    Autofill will work to pull the formulas into new rows as long as there are at least two rows above or below the new row that contains the formula.

  • Forgot to say THANK YOU for looking at this...

    Also, instead of a helper row...I just put the "Children check" into the variance calcuation...

    =IF(COUNT(CHILDREN([Task Name]@row)) = 0, IF((ISBLANK([Actual Start]3)), 0, Duration3 - [Actual Duration]3))


  • Trying to calculate Duration on task With column titles of Punchlist Signed by Ops - Punchlist Walk w/GC-Ops using

    =[Projected Date]@row - [Actual Date]@row as the baseline using exact column heading in lieu of Projected and Actual date. Does not seem to take this. Also is row the row number of the calculation or just @row?

    Any suggestions?