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.
Comments
-
Gary,
The solution that immediately comes to mind for your situation is to create a sheet for each individual location. Then grant access for the leaders by their location, and you can manage across all locations through using reports and/or dashboards. This way you won't have leaders mistakenly modifying incorrect items since they won't have access to them. Let me know if you have any questions on how to achieve this.
Steve
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives