today I will explain all fields available for Columns in Grid View in Project for the Web.
First of all I will crate a simple Project with some Resource assigned to Tasks:
I’ve created the Schedule as well, using Timeline View:
Here I can see (visually) the Gantt Chart, and relations between Tasks.
I can adjust Columns in Grid View:
For this post I will add them all:
Now let me explain those fields one by one:
- Duration – Task duration. It can be entered or calculated according to Effort. For example, if I put effort for Task 1 = 24 hours (instead of 16), Duration will be 1,5 Days. Calculation is: 24 hours / 2 Resources = 12 hours per Resource, and 12 hours per Resource / 8 hours per day = 1,5 day!
- Assigned to – Resource(s) to whom the Task is assigned
- % complete – How much of Task is completed. I can put it, or it can be calculated by Effort completed. For example, if I put for Task 1 Effort completed = 18 hours, % completed will be 18 hours (Completed) /24 hours (Effort) = 0,75, e.g. 75%
- Depents (after) – simply – Successor(s)
- Bucket – in Which bucket is this Task (for example – Sprint 1, or Automation). If you need further explanation to Buckets, read some of my previous Blog Posts
- Depends on – simply – Predecessor
- Effort – total hours for all Resources on Task. Look in Duration above for explanation
- Effort completed – how much of effort is already done. I can enter value here (see % completed), or it can be calculated if I enter % completed
- Effort remaining – Effort – Effort completed
- Finish – Task Finish date. For example see Task 1 and Task 2:
Task 2 has Finish date – 01/10/2020. If I change it to, for example 01/13/2020 (Monday), I will move Strat date for Task 3, and the whole Schedule, as expected:
- Start – Task Start Date. It is Calculated, but If I change it, the whole Schedule will change, as well.
- Of course, you don’t have to put all those fields in Columns, just one that you really need.
Hope this helps.