Greetings!
I have modified a spreadsheet to list out project tasks and due dates as a gantt chart. I did not create the original chart or formulas-not advanced enough to do so.

I'd like to sort the data by project due date, and then task due date, as the original poster in this thread said. However, the project due date and task due dates are in the same columns. I tried moving them to different columns, but it keeps breaking the spreadsheet.

Can anyone recommend a solution?

See spreadsheet, which has projects listed with soonest due dates first. This is my desired outcome.

Thanks!
-JasmineGantt Chart - Project Milestones.xlsx