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.
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
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 Activities | Completed Activities | Pending Activities | ||
APAC | ||||
EMEA | ||||
US |
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