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
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives