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


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.
    Genevieve P. Employee Admin

    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.