Staff Widget Production Tracking

I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed, new invoices to be processed, and invoice pending(carry over from previous weeks). To be able to see the history of each week, we have invoice types nested under each week of the year.
What is the best way to set this up, without each staff member being able to see what the rest of the team is doing? I looked at having individual sheets for each staff member and then linking it to an overall sheet, but that would be quite a few sheets (1 per staff + overall). I looked at a single sheet with row sharing, but each week would require a new row request (automated updates would not work, because we would need a new set of rows for each week).
Any recommendations on how to set this up, with the most amount of automation would be greatly appreciated.
Comments
-
Hello,
If you need to prevent each staff member from seeing the other's activities, you'll want to set this up such that each staff member has their own sheets.
You can either create a report that looks across the multiple sheets (this will automatically pull values in for you based on the report criteria), OR use cell linking—not as automated but cell links can pull in the info and you can create a hierarchy in the "master sheet."
More info on reports can be found in the help center: https://help.smartsheet.com/articles/522214-creating-reports
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 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