Skip to main content

Gantt block not sorting by start date

  • September 14, 2020
  • 1 reply
  • 31 views
L

Hi there, I’m using the new Gantt Block for product planning. Overall it is great but I’m having some difficulties with sorting. Here is the situation:

  • I have a set of tasks grouped by workstream
  • Each task has a start and end date
  • I have a gantt of all the tasks, grouped workstream
  • The order of the gantt is alphabetical by workstream, rather than by start date by workstream

This means that the blocks appear all over the place. Any ideas to fix this so that the workstream with the earliest start date is at the top?

1 reply

P
Forum|alt.badge.img+18
  • Paul_Warren
  • Inspiring
  • September 14, 2020

Welcome @Lyndall_Schreiner!

Great job laying out your question and relevant base information. It looks to me like the best way to do this would be to create a new table called “Workstream”, then link each task to a “Workstream”. If you make just that one change, you wont gain much, so you might be using a Single Select Field or something similar.

However, once you have your tasks linked to a record in another table you can use a Rollup field and a Lookup field to accomplish your goal.

First, in the “Workstream” table, create a Rollup field called “Project Start Date”. Then rollup the Start Date based on the tasks linked to that workstream and use the formula: MIN(values).

Second, in the Tasks table, create a lookup field called “Project Start Date Lookup”. Then lookup the “Project Start Date” from the “Workstream” table.

Finally, group your records in the Gantt by the “Project Start Date Lookup” field. This should sort them by the earliest start date.

Honestly, I would prefer if the Gantt app could condense the projects to be stacked better when tasks are happening on the same day, but we can’t have it all :slightly_smiling_face:

I hope this helps! Feel free to share any other questions you have.

Terms & ConditionsAccessibility statement