Forum Discussion
Matrix to display total days spent on the task - Conditional formatting based on late or on-time.
Super UserChintan based on your reply, it means there must be data to show which stage each task is. Can you share some sample data in the table format?
parry2k Please see below sample data. I have sequence the Stages from New to Manage in a raw. I mean first stage is New folllowed by Preparation and so on. Please note after manage stage, the task is completed. Here in below screenshot, Task 1 is delayed because it spend 6 days in Stage New and Stage New which first stage should be completed within 4 days from created date. By the end of 4th day, the team should have completed Stage New and update it's status to Stage Preparation. While Task 5 is on time beacuse within 19 days, it's already in Manage Stage.
New - 1 to 4 Days
Preparation - 5 to 8 Days
Calculation - 9 to 18 Days
Approved - 19 to 22 Days
Manage - 23 to 28 Days
Hope it make sense.
Many thanks