3 Replies Latest reply on Sep 5, 2018 12:46 AM by Trisha Ann

    Calculated Field

    Trisha Ann

      I'm trying to show when something is "New" (aka Task Name = Initiate) and need help with the calculation.My goal is to show monthly how many Numbers were "Initiate" (aka New), In Process, and Released. Where I am having trouble is showing what is New.

       

      data:

      NUMBER
      START
      ENDTASK
      19/1/189/2/18INITIATE
      19/2/18COLLABORATE
      29/4/18INITIATE
      39/3/189/3/18INITIATE
      39/3/18COLLABORATE
      47/15/18INITIATE
      58/5/18INITIATE

       

      Any help is appreciated!