timeline help?

Question

Hello,

I am not pro at excel or googlesheet. But I need to get this task done no matter what. So there are couple of employees who update what they are doing daily on googlesheet. I have to gather everyone tasks and their works on one file so manager can see everyone tasks and progress for the month. In order to do that I used IMPORTRANGE to combine everyone data on one googlesheet. I had to put them side by side since they can keep continue updating their own file so I don't have to keep updating the row and column. But googlesheet timeline makes it impossible to show all the employees tasks on timeline at the same time. I have to change the column on settings per employees to see. Is there any other option for me to see the employees tasks as the same time?

Answer 1

Hi @Random User_412

Any issues of GoogleSheet, I suggest you post a new thread in Google community: https://support.google.com/docs/community?hl=en&sjid=14215740776691358755-EU

For Excel, you may try Power Query, and use "Group By" feature to group tasks data via Date.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---