What is the best way to show a variable timeline in one sheet, with a min and max time to complete?

csauser_crx1

I have a project with one task that could take 8 to 12 weeks to complete - what is the best way to show that variable timeline?

Should I list the task as 2 line items breaking down the timeline, possibly like the below?

1. Complete development - 8 weeks - [official work start date] - [potential 8 week end date]
2. Potential additional development time - 4 weeks - [start date of potential additional 4 weeks required] - [potential end date of 12 weeks from official work start date]

Thanks for any recommendations!

Genevieve P.

Hi @csauser_crx1

Personally, I like your idea of breaking it out like that!

You could have those two rows be Parent-Level rows, with all the sub-tasks below them, if there are any. That way if those additional weeks aren't needed you can either delete that row (and it's sub-tasks) or adjust the timeline if it doesn't need all 4 weeks.

You could also use formatting to colour the "maybe" rows a different shade (e.g. a lighter grey) until it's known whether they're needed or not.

Cheers,

Genevieve