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.