Forum Discussion
Tasks
Does this work?
=IFS(ISNUMBER(MATCH("off", B2:G2, 0)), "Off", COUNTIF(B2:G2, "<>")=0, IF(A2<TODAY(), "Delay in Task Monitoring", "Not Completed"), COUNTIF(B2:G2, "=")>0, IF(A2<TODAY(), "Delay in Task Monitoring", IF(A2=TODAY(), "In Progress", "Not Yet Due")), TRUE, "Completed")
That's needlessly complicated.
HansVogelaar I know that and it's okay only because I want it to be more accurate, and because if tomorrow comes and the person concerned does not complete the tasks, it will appear that he is late and that is enough, thank you again
- Wow, it finally works, I can't describe my happy now, I really thank you, I tired you with me a lot
I'm still not sure what you want. Perhaps
=IF(ISNUMBER(MATCH("off",B2:G2,0)),"Off",IF(COUNTIF(B2:G2,"=")=0,"Completed",IF(A2<TODAY(),"Delay in Task Monitoring",IF(A2=TODAY(),IF(COUNTIF(B2:D2,"<>")+COUNTIF(F2:G2,"<>")=0,"Not Completed","In Progress"),IF(COUNTIF(B2:D2,"<>")+COUNTIF(F2:G2,"<>")=0,"Not Yet Due","In Progress")))))
or else
=IF(ISNUMBER(MATCH("off",B2:G2,0)),"Off",IF(COUNTIF(B2:G2,"=")=0,"Completed",IF(A2<TODAY(),"Delay in Task Monitoring",IF(A2=TODAY(),IF(COUNTIF(B2:D2,"<>")+COUNTIF(F2:G2,"<>")=0,"Not Completed","In Progress"),"Not Yet Due"))))
- I never blame you. I truly thank you for so much time you have given me. And I know the problem is the difference between "not completed" and "in progress", my main idea is that if the person concerned starts the day and he still hasn't started filling in the tasks, the phrase "not completed" appears, and if it starts to fill in the tasks, it shows “in progress.” This is exactly the difference.
I give up.
- It works but what about "not completed" 🙂
=IFS(ISNUMBER(MATCH("off", B2:G2, 0)), "Off", ((B2<>"")+(C2<>"")+(D2<>"")+(F2<>"")+(G2<>""))=0, IF(A2<TODAY(), "Delay in Task Monitoring", "Not Yet Due"), ((B2="")+(C2="")+(D2="")+(F2="")+(G2=""))>0, IF(A2<TODAY(), "Delay in Task Monitoring", IF(A2=TODAY(), "In Progress", "Not Yet Due")), TRUE, "Completed")
- It's work and a great idea, but like you told me earlier, it's going to be complicated because the problem arose is that the later dates show "not completed" and not show "not yet due".
How about
=IFS(ISNUMBER(MATCH("off", B2:G2, 0)), "Off", ((B2<>"")+(C2<>"")+(D2<>"")+(F2<>"")+(G2<>""))=0, IF(A2<TODAY(), "Delay in Task Monitoring", "Not Completed"), ((B2="")+(C2="")+(D2="")+(F2="")+(G2=""))>0, IF(A2<TODAY(), "Delay in Task Monitoring", IF(A2=TODAY(), "In Progress", "Not Yet Due")), TRUE, "Completed")