Forum Discussion
Matrix to display total days spent on the task - Conditional formatting based on late or on-time.
Super UserChintan I think I understood what you are looking for and I have some questions:
- how do you find out if the task is on time or delayed?
- what happens if it is more than 28 days?
- what if tasks are already completed? Does that get added to it? If yes, if a task is already completed, do you still want to calculate the day based on today's date which in my opinion doesn't make sense?
I think you need to look at the bigger picture and ask your questions accordingly.
parry2k Thank you for your response.
-- Regarding on time or delayed, each task has five stages and it should be completed in 28 days. Stage 1 should be completed within 4 days of startdate, Stage 2 should be completed within 8 days of startdate, Stage 3 should be completed within 18 days of startdate, Stage 4 should be completed within 22 days of startdate and last Stage 5 should be completed within 28 days of startdate. For example; if Task 1 is in Stage 2 (which means it should be completed within 8 days of startdate) doesn't change it's status to Stage 3 in 8 days then it should be grey colour else blue colour.
-- if it more than 28 days and still task is not completed we will just colour it grey from Day 1 and Day 28.
-- No, completed task will be filter out and will not be included. So all good with Completed.
Let me know if you have further question. I am excited for the solution.
Thank you 🙂
