Timeline view task bar displaying the task name + % completion

Léa Darnault

Hello there, I wanted to check if someone knows a way to reflect the task name and the % completion on the task bar in the timeline view.
For now the best way I found is to go to timeline view>project settings>item title>%completion and therefore showing only the % completion in the task bar. But by doing this, then I loose the task name in the task bar.
Many thanks in advance.

kowal

hi Léa Darnault,

Only one column can be shown on the task bar.

But you can always create helping function column and inside put formula like =%completion@row+" "+taskname@row so you can now have both of those information in one column and this column can be shown on the bar.

hope this helps.

Léa Darnault

Hi Tomasz! Thank for this, it works, although I am struggling to find a way to display the % completion as a percentage. Would you maybe know a way to apply format to this part of the formula so that it shows for example:
"Task Name 50%" and not just "Task Name 0.5" as it does now?

Thanks!

Brian Wilson DC

@Léa Darnault

You can make the task name appear how you'd like it with some tinkering to the formula that @kowal provided you. It will look like the equation below.

=[Task Name]@row + " " + (100 * [% Complete]@row) + "%"

Essentially, you are asking it to take the Task Name, add a space, then multiply the existing percentage by 100 to get a whole number and then put a percentage sign after it. So if I take a task name of "Bob" and a % Complete column of 50% it will make it look like the following:

And selecting the Project Setting for your timeline of the "% Complete Plus Task Name" column it will appear like this on your timeline:

I hope that helps!

kowal

hi @Léa Darnault,

sorry for late reply as you did not tag me I did not get any notification.

@Brian Wilson DC is perfectly right you just need to multiply *100 the vaue plus add "%" sign to it to see percentage done.

kowal

hi @Léa Darnault,

sorry for late reply as you did not tag me I did not get any notification.

@Brian Wilson DC is perfectly right you just need to multiply

Léa Darnault

Thank you very much, this has worked perfectly !!