Best way to layout sheet for multiple user data entry and charting
New to the program so am looking for some guidance to head down the right path.
Lets say I have 10 different metrics that need to be updated once a week for 52 weeks. Each metric is owned by a different employee. I want them to enter their data, not send to me to enter. At the end of the day I need to be able to print one full page chart for each metric to display in a project control room. Would also like to be able to have each chart in a live dashboard on smartsheet.
Some options I think:
Create a sheet with each metric in a different row, with the 52 weeks as columns. This way I think I assign a user to the row and send them requests to update, etc.
Have each metric in a column, with the weeks a different rows. Not sure I can assign a column to someone, but perhaps give everyone access to the sheet and hope they don't mess with someone elses stuff.
With both of the above options, I think I can create a dashboard tab with one chart targeting whatever data I want, be able to print them, or also pull the data into an overall dashboard that has all the charts in one smartsheet dashboard.
Is there a better option of the above, or something else entirely? Any direction is appreciated. Thank you.