• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help..Consolidated Activity Tracker

ujjwaljha1812

New Member
Hi Friends.
I have 3 teams (APAC, EMEA and US) who have respective activities to perform. I have created a manual tracker but it is a bit challenging to pull summary of all. It is because the the activities are aligned to different users and different countries. I tried thinking of doing it ion excel but did not get through because of multiple users and countries.

If you can help in getting a consolidated activity list so that I can get a summary of total activities due on certain date, completed activities, pending activities.
Activities Due on#Date
Total ActivitiesCompleted ActivitiesPending Activities
APAC
EMEA
US
I have attached the activity list here.
For APAC & EMEA - Activity list is in column A, Name of employee is in row 1, name of country is in row 2

Regards
Ujjwal
 

Attachments

  • EMEA- Activity Tracker Dec'19.xlsx
    118.3 KB · Views: 5
  • APAC Task Tracker -Dec'19.xlsx
    61.3 KB · Views: 1
  • Americas Checklist Dec 19.xlsx
    61.5 KB · Views: 1
Back
Top