none
Show Status of "Finished" Task RRS feed

  • Question

  • I want to know which tasks finished late or on Schedule. How would I do this?  Would I have to create a custom column or is there a column I don't know about.

    Thursday, June 22, 2017 1:49 PM

Answers

  • First thing is to save a baseline. If you want to know if a task has been finished late or on schedule, you need to have something to compare with. Thus you should save a baseline.

    Then the FINISH VARIANCE is the baseline finish minus the finish date. So you could use the finish variance column, eventually creating a custom field using this finish variance qith a formula such as:

    iif ([finish variance] <=0, "On Schedule", "Late")


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    • Marked as answer by Adobe81 Thursday, June 22, 2017 5:53 PM
    Thursday, June 22, 2017 2:17 PM
    Moderator

All replies

  • First thing is to save a baseline. If you want to know if a task has been finished late or on schedule, you need to have something to compare with. Thus you should save a baseline.

    Then the FINISH VARIANCE is the baseline finish minus the finish date. So you could use the finish variance column, eventually creating a custom field using this finish variance qith a formula such as:

    iif ([finish variance] <=0, "On Schedule", "Late")


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    • Marked as answer by Adobe81 Thursday, June 22, 2017 5:53 PM
    Thursday, June 22, 2017 2:17 PM
    Moderator
  • Adobe81,

    In addition to Guillaume's expert guidance you might want to take a look at the Status field. If you add it as a column in the Gantt Chart view, hover your mouse over the column heading and then hit F1. That will bring up the help file for that field.

    John

    Thursday, June 22, 2017 3:05 PM
  • There is a column you don't know about, several, actually. Switch from the entry table to the tracking table (view, tables). The first two columns are the actual start date/time and the actual finish date/time. These are for recording the facts, and when the occur you will replace the planned or scheduled date/time.

    If you want to know what is "on schedule" you must define what "on schedule" means. You are also going to have to define what "early" and "late" mean. You planned for the task to start on some date/time, that being the earliest possible given whatever predecessors, date constraints and resource limitations may be in effect. You saved that plan as a baseline so that you could remember and refer back to that date after the start of the task has been re-scheduled or has actually occurred (or else you just wrote it down in a notebook, or saved the file with another name). So if the current scheduled or actual start date/time is the same as what was planned when you saved the baseline, the task is "on schedule" with respect to the baseline start date/time, as of whenever the baseline was saved.

    But the task also has a duration and a finish date/time, so the same comparison applies to both of those too.

    Otherwise, you could just ignore the start and the duration and define "on schedule" as being if the finish date/time, either as currently scheduled or actual, is the same as the baseline finish.

    Any help?

    Thursday, June 22, 2017 11:27 PM
  • Yes, this is helpful!  Thank you!

    • Edited by Adobe81 Friday, July 7, 2017 1:09 PM
    Friday, July 7, 2017 1:09 PM