Hello experts,
I have 4 different tabs in sheets for 4 different departments, which lists different tasks. The format is same for all 4 sheets, having headers as Project Name, Owner, Area, IssueDate, Task Type, Status, Comments.
I need to list all the tasks in a new tab (Task List) which should list only the tasks from first 4 sheets based on the status and owner.
For example,
- from 1st sheet I want to see the task owned by John and whose status is either "On Track" or "Delayed"
- from 2nd sheet I want to see the task owned by Jacob and whose status is either "On Track" or "Delayed"
- from 1st sheet I want to see the task owned by Oliver and whose status is either "On Track" or "Delayed"
- from 1st sheet I want to see the task owned by Samantha and whose status is either "On Track" or "Delayed"
So basically all the running tasks owned by these 4 people should come in "Task List" tab.
Output table should be in same format as other sheets. See attached samplefile.
Can someone please help me in achieving this?
Thanks a lot.
Cheers
Puneet
Bookmarks