Hello, can you show the start date of a task next to your gantt chart?
Best Answer
-
Try
=Name@row + " - " + (LEFT(Start@row, 8))
Answers
-
Hi Younes,
Try this, in Gantt View, select Edit Project Settings, the Gantt Timescale Settings, then "Display Label For" and select Start Date.
A
-
so there is no way to show both the name and the start date?
-
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
-
Is there a formula that automatically copys those two other columns?
-
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.
-
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
-
okay and i just copy paste this or do i have to change some things besides task name and start date?
-
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.
-
it comes out as #UNPARSEABLE 😓
-
Can you send me you r formula?
-
=Dept@row + " - " + [Name]@row + " - " + (LEFT([Start]@row, 8))
-
Name and Start are my column names
-
Try
=Name@row + " - " + (LEFT(Start@row, 8))
-
it worked!!! thank you so much for your help youre a hero
-
No problem Younes.
Help Article Resources
Categories
Check out the Formula Handbook template!
