Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I share permission to the sheet to the leaders they are able to see the status of the other locations tasks and can also accidentally sign off on the wrong location. Is there a way to only allow them to see their location-specific tasks and sign off only on these without creating a separate sheet for each location? It also makes the calendar view very inundated with the same task.