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")
What is the difference between "In progress" and "Not completed"?
HansVogelaar The difference between 'Not completed' and 'in progress' is that in the first phrase no filled in cell in the range of cells is filled, while in seconde phrase in progress a part of the range of cells is filled
As variant
=IF( SUM(--(range = "off")), "Off", LET( n, COLUMNS(range), k, SUM(--ISBLANK(range)), IF(k = n, "Not completed", IF(k = 0, "Completed", "In progress")) ) )- Thank you very much. I appreciate your effort.
but an additional idea occurred to me, which I know would complicate the equation a lot, but would be more subtle. I want to link the formula with today's date or a certain number of days, because if the task is "in progress" or "not completed", but the next day comes and the task is still in progress or not completed, another phrase appears, which is "delayed in task monitoring"
forgive me for this request, which I think will complicate the equation, but I think it will make the tasks monitored with a lot of accuracy, also because i want to monitor tasks on a daily basis
thank you very much again.Could you please illustrate on the sample how it is structured, where are dates and where is other information, which part is to check if to filled or not, etc.
Ah, that's different from
if any of the cells is not filled, ther phrase appears "not completed"
Let's say you want to look at D2:G2.
=IFS(ISNUMBER(MATCH("off", D2:G2, 0)), "Off", COUNTIF(D2:G2, "<>")=0, "Not Completed", COUNTIF(D2:G2, "=")>0, "In Progress", TRUE, "Completed")
This can be filled down.
- Thank you, I appreciate your effort
