Nandakumar
Member
Hi Everyone,
I need a help on the below.
I have task list for each employee in separate sheet for each country.
They will update whether it is started, work-in-progress, pending or completed and they will have either specific tasks and some may have all tasks.
In the summary sheet, we should have consolidation as either completed (if all employees completed the task),Work-in-progress (even one employee is either not started,WIP though other employee has completed the task) and not started if none of the employees didnt started the task.
I have entered manually for first two rows.
Request team kind help.
Attached herewith excel sheet for kind perusal.
I need a help on the below.
I have task list for each employee in separate sheet for each country.
They will update whether it is started, work-in-progress, pending or completed and they will have either specific tasks and some may have all tasks.
In the summary sheet, we should have consolidation as either completed (if all employees completed the task),Work-in-progress (even one employee is either not started,WIP though other employee has completed the task) and not started if none of the employees didnt started the task.
I have entered manually for first two rows.
Request team kind help.
Attached herewith excel sheet for kind perusal.