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

# Formula Question

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

 Number Task Name Task Result Start Date End Date 1 A Complete 8/1/2018 8/3/2018 1 B Approved 8/3/2018 8/13/2018 1 C Complete 8/13/2018 8/20/2018 1 D Complete 8/20/2018 8/21/2018 1 E 8/21/2018 2 A Complete 9/1/2018 9/2/2018 2 B Approved 9/2/2018 9/4/2018 2 C 9/4/2018 3 A 8/2/2018 4 A Complete 9/1/2018 9/1/2018 4 B Approved 9/1/2018 9/2/2018 4 C Complete 9/2/2018 9/2/2018 4 D Complete 9/2/2018 9/3/2018 4 E Complete 9/3/2018 9/3/2018 4 F Released 9/3//2018 9/4/2018 5 A Complete 1/1/2018 1/1/2018 5 B Approved 1/1/2018 1/2/2018 5 C Complete 1/2/2018 1/15/2018 5 D Complete 1/13/2018 1/17/2018 5 E Complete 1/17/2018 1/18/2018 5 F Released 1/18/2018 9/2/2018
• ###### 1. Re: Formula Question

So how would you like to show # 5? Do you want to show it just once or multiple times? Can you give us an example of how you'd like to account for it?

• ###### 2. Re: Formula Question

HI Ken!

I think it's ok if the result shows 1 time for each Number.

I need in the end something like this.

Gray = New

Light Green = In Process

Dark Green = Released

Thanks for your help!