2 Replies Latest reply on Sep 7, 2018 4:25 AM by Trisha Ann

    Formula Question

    Trisha Ann

      HI!

      I am stumped and need some assistance. My goal is that I need a stacked bar that shows New, In process and Released Numbers for each month. I feel like I need a formula to add a column identifying the status (New, In process, Released). Where I feel stuck is on Number 5 in the data below. In Number 5, it shows it started in Jan. but was released in Sept. If you have any ideas on how best to manage this I would appreciate the help!

       

      NEED:

       

      Stacked Bar Graph that shows by each month how many Numbers are New, In Process, Released.

      • New = Start Date of that Month for Task Name "A"
      • In Process = Not New and Not Released
      • Released = Task Name "F"  Task Result = "Released"

       

       

      EXAMPLE DATA:

          -Need to add Status Column with Monthly Status

       

      NumberTask NameTask ResultStart DateEnd Date
      1AComplete8/1/20188/3/2018
      1BApproved8/3/20188/13/2018
      1CComplete8/13/20188/20/2018
      1DComplete8/20/20188/21/2018
      1E8/21/2018
      2AComplete9/1/20189/2/2018
      2BApproved9/2/20189/4/2018
      2C9/4/2018
      3A8/2/2018
      4AComplete9/1/20189/1/2018
      4BApproved9/1/20189/2/2018
      4CComplete9/2/20189/2/2018
      4DComplete9/2/20189/3/2018
      4EComplete9/3/20189/3/2018
      4FReleased9/3//20189/4/2018
      5AComplete1/1/20181/1/2018
      5BApproved1/1/20181/2/2018
      5CComplete1/2/20181/15/2018
      5DComplete1/13/20181/17/2018
      5EComplete1/17/20181/18/2018
      5FReleased1/18/20189/2/2018