Starting with a Sheet, that Now needs to be a Gantt - how does one get roll-up summary info

GarryD2

We started with what we thought was going to be a simple sheet that has grown and now had Target Start and Target End date columns. Now we look at is as a Gantt (again not started as a Gantt sheet)

So we made parent and child rows, have the settings in Gantt view looking at these date columns. However, if you indent/make a child, the parent row does not populate the roll up data such as the dates. Is there a way to add this or any needed column to perform this now that we are needing to look at it as a Gantt chart with parent and child rows?

We currently do not have a duration and predecessor/successor columns.

Gia Thinh

Hi @GarryD2,

Navigate to "Edit Project Settings" and enable Dependecies. It will work for you.

GarryD2

Thanks, will this then also automatically then summarize date ranges of parents like traditional Gantt would do? As I was going through adding Min and Max calcs if I had to on all my parent rows. However if adding this also adds Min Max to date columns for parents that would be great.

Gia Thinh

Yes, it will