Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Child tasks indent into parent tasks.

Dear Fellows,    Please help me out step by step to indent the child tasks into parent tasks in Table. And make the parent tasks bold.  Looking forward for your kind support. As I tried to get som...
Need Help
  • DaFloDo's avatar
    DaFloDo
    8 years ago

    hi,@bix

     

    Here is an idea without drilldown, just visual indenting of the taskname, assumed you have a SortIndex within your datasource or can generate it.

     

    You could calculate a column "IndentedTaskName" by prepending blanks depending on the level of the task.

    In case you do not have the task-level information, maybe you could calculate that too: for example if ID starts with "F." then TaskLevel=0 otherwise TaskLevel = number of dots in ID

     

    If you only have two levels as in your screenshot it would be even simpler:

    TaskLevel = IF(Left('Tasks'[ID]; 2)= "F."; 0; 1) 

    IndentedTaskName = CONCATENATE(REPT("　"; [TaskLevel]); [TaskName])

     

     

     

    Using conditional formatting, you could then style the tasks depending on TaskLevel.

     

    I think the ID column of your screenshot does not contain the parent child relationship and sort order of tasks.

     

    Best Regards,

    Florian

DaFloDo's avatar
DaFloDo
Icon for Resolver I rankResolver I
8 years ago

hi,@bix

 

Here is an idea without drilldown, just visual indenting of the taskname, assumed you have a SortIndex within your datasource or can generate it.

 

You could calculate a column "IndentedTaskName" by prepending blanks depending on the level of the task.

In case you do not have the task-level information, maybe you could calculate that too: for example if ID starts with "F." then TaskLevel=0 otherwise TaskLevel = number of dots in ID

 

If you only have two levels as in your screenshot it would be even simpler:

TaskLevel = IF(Left('Tasks'[ID]; 2)= "F."; 0; 1) 

IndentedTaskName = CONCATENATE(REPT("　"; [TaskLevel]); [TaskName])

 

 

 

Using conditional formatting, you could then style the tasks depending on TaskLevel.

 

I think the ID column of your screenshot does not contain the parent child relationship and sort order of tasks.

 

Best Regards,

Florian

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks. 

 

So far, ID column indented. But still I am looking for to Bold or change color for specific row. Such as, I want to bold or color change of parent task or milestone.