I need help with connecting a new row to a different doc. We have a doc that manage all the tasks for our employees. We want that every new row we add that is assign to a person will also added to a different doc that is special just for his or her tasks and will combine all the tasks that the person must complete.
If in one row we wrote a task or information to someone and assigned the task to him through the cell of people (where you can choose a user) then that row will also be added to a seperate file that is belong only to him and collects all the information he was ever tagged in.
Is there a way to do it? thank you!