Dynamic View Options for Sheet
Hello,
I'm working on a quarterly goal review process. I need to keep all employees in the department on one main sheet with each employees' manager noted in a contact column. Then I've created a dynamic view based on current user (for the manager contact column) so each manager can view and evaluate the goals for each of their employees. I'm trying to figure out how to be able to filter the dynamic view so the manager can see the columns for a specific quarter or all quarters for their team. I can't figure out the best way to do this from the main sheet because I have multiple columns for each quarter. Any suggestions? Here's an example sheet for reference:
Answers
-
In the Dynamic View - the actual view (not the setup) in the upper left corner there is an option to create filters. You can create a shared filter for each quarter. The managers can also create their own filters.
Not sure if this answers your question or not.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives