How do you adjust the parent task to only show months worked? (rather than being a continuous line)

Currently, we have tasks set under a parent, but the parent will only show between the start and end date. If there is a 3 month gap in between, how do you display this in the parent?

For example one task is done in January and another in March. - How do you show a split in February?

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    This is one of my pet-peeves about the product but actual time gone by is apparently a huge priority for project management. If you want to create a Time on Task column you can run a formula to calculate each sub row by subtracting the end date from the start date to get an actual number, then in the parent rows you can sum the children rows.

    Formula for the child rows: = [End Date]@row - [Start Date]@row

    Formula for the parent rows: =SUM(CHILDREN())