Follow
Export the Task List with Child Tasks Indented

Problem

I cannot identify parent/child relationships in an exported task list. 

Solution

You can maintain the distinction of parent/child relationships in an exported task list by doing the following: 

  1. Navigate to the Project with the Task list you'd like to export.
  2. Click the View drop-down menu, and select New View.
  3. Name the filter in the top-left corner of the screen.
  4. Click in the Task Name column header.
    task-name-column-header.png
  5. Select Switch to Text Mode in the top-right corner.
  6. Click anywhere in the textbox to edit text, and remove all existing text.
  7. Paste the following text:
    displayname=
    linkedname=direct
    namekey=name
    querysort=name
    textmode=true
    valueexpression=IF({indent}<1,{name},IF({indent}<2,CONCAT(" - ",{name}),IF({indent}<3,CONCAT(" - - ",{name}),IF({indent}<4,CONCAT(" - - - ",{name}),CONCAT(" - - - - ",{name})))))
    valueformat=HTML
  8. Click Save.
  9. Click Save View.

When you export your task list, make sure to select the view you created above.

 

This article last updated on 2018-03-06 16:41:56 UTC