Hello, can you show the start date of a task next to your gantt chart?

Younes Amine

like this other tool can?

A_C

Try

=Name@row + " - " + (LEFT(Start@row, 8))

A_C

Hi Younes,

Try this, in Gantt View, select Edit Project Settings, the Gantt Timescale Settings, then "Display Label For" and select Start Date.

A

Younes Amine

so there is no way to show both the name and the start date?

A_C

You can create a helper column that contains the column information you need. Then use the helper column as the label.

E.g., =Col1 + " - " + Col2 + " - " + Col3 etc.

A

Younes Amine

Is there a formula that automatically copys those two other columns?

A_C

Once you have created the formula in the helper column, you can convert the formula in the cell to be column formula.

Example formula is:

=Dept@row + " - " + [Task Name]@row + " - " + [Start Date]@row

We use long names on reports, we structure them to save space, as we only use the long name in the reports, e.g., Programme Ref + Project Ref + Workstream + Task Name etc.,

You'll need to put the cursor over the cell with the formula in it, right-click then select convert to column formula, you can lock the column as well, then hide the Helper Column (HC) away if you don't need it.

A_C

Just realised, if you want to strip the time off use this:

=Dept@row + " - " + [Task Name]@row + " - " + (LEFT([Start Date]@row, 8))

We use the time on some of our plans.

A

Younes Amine

okay and i just copy paste this or do i have to change some things besides task name and start date?

A_C

You can copy and paste, then update the column names to your ones, in the order that you want them to appear in the long name.

You helper column will need to stay as Text/Number.

Younes Amine

it comes out as #UNPARSEABLE 😓

A_C

Can you send me you r formula?

Younes Amine

=Dept@row + " - " + [Name]@row + " - " + (LEFT([Start]@row, 8))

Younes Amine

Name and Start are my column names

A_C

Try

=Name@row + " - " + (LEFT(Start@row, 8))

Younes Amine

it worked!!! thank you so much for your help youre a hero

A_C

No problem Younes.