How can I show Today, where someone stands within the graph?
I am trying to build something that will show %complete, desired %, AND where the trainee stands in comparison to the milestones all in one graph. From the progression status indicators, I have a few items that show some data. From the trainees start date and selected target finish date, I have made an equation to create milestones in between. My hope with this is to give some indicator to help determine if they are on track or not.
Now that I have this made, I am wanting to show where the trainee stands TODAY in this 8 months long process. i.e. if we are in month 2, we are ahead... if we are in month 4+ we are behind.
My first approach to answering this was to create the Status column. The equation is shown below. I feel that I an getting close to my answer but it is not complete. What else can I calculate and visualize to show if someone is behind or ahead of the set start and targeted finish dates?
Help Article Resources
Check out the Formula Handbook template!