Forum Discussion
Project Count Over time that adds uncompleted projects to future time periods
Hi, I am trying to track project progress across 4 stages, (Committed, In Progress, Testing and Done). The tricky part is I want to take the max status each quarter and if it hasn't reached done...
Hi Anonymous
Can you provide some sample data or picture?
Best Regards!
Yolo Zhu
Hi,
Something like this
| Project | Status | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 |
| A | Committed | 1 | |||
| A | In Progress | 1 | 1 | 1 | |
| A | Accepted | ||||
| A | Done | ||||
| B | Committed | 1 | |||
| B | In Progress | ||||
| B | Accepted | ||||
| B | Done | 1 | |||
| Project would pick up max status in quarter and put it in that status. | |||||
| Anything not in Done Status would carry on indefinitely. Project A would remain in the last status until an update is made. THanks! | |||||
Hi, Did you ever have a solution to this? It feels like there should be a way to add an uncompleted project to a project inventory.
Thanks