1 Reply Latest reply on Mar 29, 2016 8:56 PM by Bill Lyons

    Creating a calculated field to return dependencies

    Maulik Patel

      There are tasks that have unique identifiers. Some of these tasks are dependent on another task. I am trying to write a code that allows me to pull the "workstream" from the dependent task.

       

      Each id contains:

      • ID
      • Dependency
      • Work stream

       

      For example if the task ID = 319, and it is dependent on 321, I wouldreturn the "Workstream" of 321 - which is a string. If there is no "Dependency" I want to return null. I'm have a filter for the "Dependency" and am only returning values if there is a "Dependency".

       

      Thanks!